MySQL Manual
9 MySQL APIs
- 9.1 MySQL C API
- 9.1.7 C API Prepared Statement Function Descriptions
- 9.1.7.1
mysql_prepare() - 9.1.7.2
mysql_param_count() - 9.1.7.3
mysql_prepare_result() - 9.1.7.4
mysql_bind_param() - 9.1.7.5
mysql_execute() - 9.1.7.6
mysql_stmt_affected_rows() - 9.1.7.7
mysql_bind_result() - 9.1.7.8
mysql_stmt_store_result() - 9.1.7.9
mysql_stmt_data_seek() - 9.1.7.10
mysql_stmt_row_seek() - 9.1.7.11
mysql_stmt_row_tell() - 9.1.7.12
mysql_stmt_num_rows() - 9.1.7.13
mysql_fetch() - 9.1.7.14
mysql_send_long_data() - 9.1.7.15
mysql_stmt_close() - 9.1.7.16
mysql_stmt_errno() - 9.1.7.17
mysql_stmt_error() - 9.1.7.18
mysql_stmt_sqlstate()
- 9.1.7.1
9.1.7.4 mysql_bind_param()
my_bool mysql_bind_param(MYSQL_STMT *stmt, MYSQL_BIND *bind)
Description
mysql_bind_param() is used to bind data for the parameter markers
in the SQL statement that was passed to mysql_prepare(). It uses
MYSQL_BIND structures to supply the data. bind is the address
of an array of MYSQL_BIND structures.
The client library expects the array to contain an element for each
`?' parameter marker that is present in the query.
Suppose you prepare the following statment:
INSERT INTO mytbl VALUES(?,?,?)
When you bind the parameters, the array of MYSQL_BIND structures must
contain three elements, and can be declared like this:
MYSQL_BIND bind[3];
The members of each MYSQL_BIND element that should be set are described
in section 9.1.5 C API Prepared Statement Datatypes.
Return Values
Zero if the bind was successful. Non-zero if an error occurred.
Errors
CR_NO_PREPARE_STMT- No prepared statement exists.
CR_NO_PARAMETERS_EXISTS- No parameters exist to bind.
CR_INVALID_BUFFER_USE- Indicates if the bind is to supply the long data in chunks and if the buffer type is non string or binary.
CR_UNSUPPORTED_PARAM_TYPE-
The conversion is not supported. Possibly the
buffer_typevalue is illegal or is not one of the supported types. CR_OUT_OF_MEMORY- Out of memory.
CR_UNKNOWN_ERROR- An unknown error occurred.
Example
For the usage of mysql_bind_param(), refer to the Example from
section 9.1.7.5 mysql_execute().
