(mysql.info) mysql-stmt-bind-param

Info Catalog

(mysql.info) mysql-stmt-attr-set

(mysql.info) c-api-prepared-statement-functions

(mysql.info) mysql-stmt-bind-result

 
 22.2.7.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 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 an 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];
 
 The members of each `MYSQL_BIND' element that should be set are
 described in  c-api-prepared-statement-datatypes.
 
 *Return Values*
 
 Zero if the bind was successful. Non-zero if an error occurred.
 
 *Errors*
 
    * `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_type' value
      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_stmt_bind_param()', refer to the Example from
  mysql-stmt-execute.
 

Info Catalog

(mysql.info) mysql-stmt-attr-set

(mysql.info) c-api-prepared-statement-functions

(mysql.info) mysql-stmt-bind-result