Search Results
https://dev.mysql.com/doc/c-api/8.4/en/mysql-get-option.html
int mysql_get_option(MYSQL *mysql, enum mysql_option option, const void *arg) Description Returns the current value of an option settable using mysql_options(). The following table shows which variable type to use for each option value. The option ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-info.html
String format: Records: 3 Duplicates: 0 Warnings: 0 LOAD DATA String format: Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 ALTER TABLE String format: Records: 3 Duplicates: 0 Warnings: 0 UPDATE String format: Rows matched: 40 Changed: 40 Warnings: 0 ... const char * mysql_info(MYSQL *mysql) Description Retrieves a string providing information about the most recently executed statement, but only for the statements listed ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-reload.html
int mysql_reload(MYSQL *mysql) Description Asks the MySQL server to reload the grant tables. Use mysql_real_query() or mysql_query() to issue an SQL FLUSH PRIVILEGES statement instead. CR_SERVER_LOST The connection to the server was lost during the ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-sqlstate.html
For example, the mysql client program displays errors using the following format, where 1146 is the mysql_errno() value and '42S02' is the corresponding mysql_sqlstate() value: $> SELECT * FROM no_such_table; ERROR 1146 (42S02): Table ... const char ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stat.html
This includes uptime in seconds and the number of running threads, questions, reloads, and open tables. const char * mysql_stat(MYSQL *mysql) Description Returns a character string containing information similar to that provided by the mysqladmin ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-insert-id.html
Use this function after you have executed a prepared INSERT statement on a table which contains an AUTO_INCREMENT field. uint64_t mysql_stmt_insert_id(MYSQL_STMT *stmt) Description Returns the value generated for an AUTO_INCREMENT column by the ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-store-result.html
After invoking mysql_real_query() or mysql_query(), you must call mysql_store_result() or mysql_use_result() for every statement that successfully produces a result set (SELECT, SHOW, DESCRIBE, EXPLAIN, CHECK TABLE, and so forth). You need not call ... MYSQL_RES * mysql_store_result(MYSQL *mysql) Description Note mysql_store_result() is a synchronous ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/mysql-threads.html
If the server is started with the --flush_time=val option, a dedicated thread is created to flush all tables every val seconds. The MySQL server creates the following threads: Connection manager threads handle client connection requests on the ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins-client-side.html
Declare the client-side plugin descriptor with the mysql_declare_client_plugin() and mysql_end_client_plugin macros (see Section 4.4.2.3, “Client Plugin Descriptors”). (For descriptions, see Section 4.4.2.3, “Client Plugin Descriptors”.) ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins.html
Authentication plugins enable the use of authentication methods other than the built-in method of passwords stored in the mysql.user system table. MySQL supports pluggable authentication, in which plugins are invoked to authenticate client ...