6.3 C API Prepared Statement Function Reference

The following table summarizes the functions available for prepared statement processing. For greater detail, see the descriptions in Section 6.4, “C API Prepared Statement Function Descriptions”.

Table 6.3 C API Prepared Statement Functions

Name	Description	Deprecated
`mysql_stmt_affected_rows()`	Number of rows changed/deleted/inserted by last prepared `UPDATE`, `DELETE`, or `INSERT` statement
`mysql_stmt_attr_get()`	Get attribute value for prepared statement
`mysql_stmt_attr_set()`	Set attribute value for prepared statement
`mysql_stmt_bind_named_param()`	Associate application data buffers with named and unnamed parameter markers in prepared statement
`mysql_stmt_bind_param()`	Associate application data buffers with parameter markers in prepared statement	Yes
`mysql_stmt_bind_result()`	Associate application data buffers with columns in result set
`mysql_stmt_close()`	Free memory used by prepared statement
`mysql_stmt_data_seek()`	Seek to arbitrary row number in prepared statement result set
`mysql_stmt_errno()`	Error number for most recently invoked MySQL prepared-statement function
`mysql_stmt_error()`	Error message for most recently invoked MySQL prepared-statement function
`mysql_stmt_execute()`	Execute prepared statement
`mysql_stmt_fetch()`	Fetch next result set row and return data for all bound columns
`mysql_stmt_fetch_column()`	Fetches data for one column of current result set row
`mysql_stmt_field_count()`	Number of result columns for most recent prepared statement
`mysql_stmt_free_result()`	Free resources allocated to statement handler
`mysql_stmt_init()`	Allocate and initialize memory for `MYSQL_STMT` structure
`mysql_stmt_insert_id()`	ID generated for an `AUTO_INCREMENT` column by previous prepared statement
`mysql_stmt_next_result()`	Return/initiate next result in multiple-result prepared statement execution
`mysql_stmt_num_rows()`	Row count from buffered statement result set
`mysql_stmt_param_count()`	Number of parameters in prepared statement
`mysql_stmt_param_metadata()`	Return parameter metadata as result set
`mysql_stmt_prepare()`	Prepare statement for execution
`mysql_stmt_reset()`	Reset statement buffers on server side
`mysql_stmt_result_metadata()`	Return prepared statement metadata as result set
`mysql_stmt_row_seek()`	Seek to row offset in prepared statement result set
`mysql_stmt_row_tell()`	Current position within prepared statement result set row
`mysql_stmt_send_long_data()`	Send long data in chunks to server
`mysql_stmt_sqlstate()`	SQLSTATE value for most recently invoked MySQL prepared-statement function
`mysql_stmt_store_result()`	Retrieve and store entire result set