Search Results
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-date-handling.html
To send temporal data values, create a prepared statement using mysql_stmt_prepare(). The binary (prepared statement) protocol enables you to send and receive date and time values (DATE, TIME, DATETIME, and TIMESTAMP), using the MYSQL_TIME ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-function-descriptions.html
To prepare and execute queries, use the functions described in detail in the following sections. All functions that operate with a MYSQL_STMT structure begin with the prefix mysql_stmt_.
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-interface-usage.html
To prepare and execute a statement, an application follows these steps: Create a prepared statement handler with mysql_stmt_init(). To prepare the statement on the server, call mysql_stmt_prepare() and pass it a string containing the SQL statement.
https://dev.mysql.com/doc/c-api/8.4/en/c-api-thread-function-descriptions.html
To create a threaded client, use the functions described in the following sections.
https://dev.mysql.com/doc/c-api/8.4/en/mysql-hex-string.html
unsigned long mysql_hex_string(char *to, const char *from, unsigned long length) Description This function creates a legal SQL string for use in an SQL statement. The string in the from argument is encoded in hexadecimal format, with each character ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string-quote.html
unsigned long mysql_real_escape_string_quote(MYSQL *mysql, char *to, const char *from, unsigned long length, char quote) Description This function creates a legal SQL string for use in an SQL statement. The mysql argument must be a valid, open ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string.html
unsigned long mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned long length) Description This function creates a legal SQL string for use in an SQL statement. Note mysql_real_escape_string() fails and produces an ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-init.html
MYSQL_STMT * mysql_stmt_init(MYSQL *mysql) Description Creates and returns a MYSQL_STMT handler. The handler should be freed with mysql_stmt_close(), at which point the handler becomes invalid and should no longer be used. See also Section 6.2, ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-thread-init.html
bool mysql_thread_init(void) Description This function must be called early within each created thread to initialize thread-specific variables. Calling mysql_thread_init() is automatically handled by mysql_init(), mysql_library_init(), ...
https://dev.mysql.com/doc/c-api/8.4/en/query-results.html
In addition to the result set returned by a query, you can also get the following information: mysql_affected_rows() returns the number of rows affected by the last query when doing an INSERT, UPDATE, or DELETE. With mysql_store_result(), ...