Search Results
https://dev.mysql.com/doc/c-api/8.4/en/mysql-list-fields.html
Instead, use mysql_real_query() or mysql_query() to execute a SHOW COLUMNS statement. MYSQL_RES * mysql_list_fields(MYSQL *mysql, const char *table, const char *wild) Description Note mysql_list_fields() is deprecated and is subject to removal in a ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-num-rows.html
mysql_num_rows() is intended for use with statements that return a result set, such as SELECT. For statements such as INSERT, UPDATE, or DELETE, the number of affected rows can be obtained with mysql_affected_rows(). uint64_t ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-reset-connection.html
Reinitializes session system variables to the values of the corresponding global system variables, including system variables that are set implicitly by statements such as SET NAMES. int mysql_reset_connection(MYSQL *mysql) Description Resets the ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-set-local-infile-handler.html
void mysql_set_local_infile_handler(MYSQL *mysql, int (*local_infile_init)(void **, const char *, void *), int (*local_infile_read)(void *, char *, unsigned int), void (*local_infile_end)(void *), int (*local_infile_error)(void *, char*, unsigned ...It enables application programs to exert control over local (client-side) data file ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-shutdown.html
An alternative to mysql_shutdown() is to use the SHUTDOWN SQL statement. int mysql_shutdown(MYSQL *mysql, enum mysql_enum_shutdown_level shutdown_level) Description Note mysql_shutdown() is deprecated and will be removed in a future version of ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-affected-rows.html
uint64_t mysql_stmt_affected_rows(MYSQL_STMT *stmt) Description mysql_stmt_affected_rows() may be called immediately after executing a statement with mysql_stmt_execute(). For a description of what the affected-rows value returned by this function ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-data-seek.html
void mysql_stmt_data_seek(MYSQL_STMT *stmt, uint64_t offset) Description Seeks to an arbitrary row in a statement result set. This function requires that the statement result set structure contains the entire result of the last executed query, so ...The offset value is a row number and should be in the range from 0 to ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-free-result.html
bool mysql_stmt_free_result(MYSQL_STMT *stmt) Description Releases memory associated with the result set produced by execution of the prepared statement. If there is a cursor open for the statement, mysql_stmt_free_result() closes it.
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-next-result.html
int mysql_stmt_next_result(MYSQL_STMT *mysql) Description This function is used when you use prepared CALL statements to execute stored procedures, which can return multiple result sets. For an example that shows how to use ...Use a loop that calls ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-param-count.html
unsigned long mysql_stmt_param_count(MYSQL_STMT *stmt) Description Returns the number of parameter markers present in the prepared statement. Return Values An unsigned long integer representing the number of parameters in a statement.