MySQL 5.6 C API Developer Guide

11.4 mysql_stmt_bind_param()

my_bool
mysql_stmt_bind_param(MYSQL_STMT *stmt,
                      MYSQL_BIND *bind)

Description

mysql_stmt_bind_param() is used to bind input data for the parameter markers in the SQL statement that was passed to mysql_stmt_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 one element for each ? parameter marker that is present in the query.

Suppose that you prepare the following statement:

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];

For a description of the members of the MYSQL_BIND structure and how they should be set to provide input values, see Chapter 9, C API Prepared Statement Data Structures.

Return Values

Zero for success. Nonzero if an error occurred.

Errors

Example

See the Example in Section 11.10, “mysql_stmt_execute()”.