You can call the mysql_stmt_init() function to create and return a MYSQL_STMT handler.
Syntax
MYSQL_STMT *
mysql_stmt_init(MYSQL *mysql)
Return values
A pointer to the MYSQL_STMT structure is returned for an execution success, and NULL is returned if the memory is insufficient.
Errors
CR_OUT_OF_MEMORY: The memory is insufficient.
Notes
The handler must be released by using mysql_stmt_close(). After being released, the handler is invalid and cannot be used.