Search Results
https://dev.mysql.com/doc/c-api/8.4/en/c-api-auto-reconnect.html
The MySQL client library can perform an automatic reconnection to the server if it finds that the connection is down when you attempt to send a statement to the server to be executed. If auto-reconnect is enabled, the library tries once to ...The ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-more-results.html
bool mysql_more_results(MYSQL *mysql) Description This function is used when you execute multiple statements specified as a single statement string, or when you execute CALL statements, which can return multiple result sets. mysql_more_results() ...
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-stmt-fetch.html
It can be called only while the result set exists; that is, after a call to mysql_stmt_execute() for a statement such as SELECT that produces a result set. int mysql_stmt_fetch(MYSQL_STMT *stmt) Description mysql_stmt_fetch() returns the next row ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-store-result.html
int mysql_stmt_store_result(MYSQL_STMT *stmt) Description Result sets are produced by calling mysql_stmt_execute() to executed prepared statements for SQL statements such as SELECT, SHOW, DESCRIBE, and EXPLAIN. By default, result sets for ...To ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-password-validation-plugins.html
To register the plugin at runtime, use this statement, adjusting the .so suffix for your platform as necessary: INSTALL PLUGIN validate_password SONAME 'validate_password.so'; For additional information about plugin loading, see Installing and ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-13.html
(Bug #28034570, Bug #90887) Setting rewriteBatchedStatements=true and useLocalTransactionState=true caused transactions to be uncommitted for batched UPDATE and DELETE statements. (Bug #27658489, Bug #89948) Rewriting prepared INSERT statements in a ... Version 8.0.13 is the latest General Availability release of the 8.0 series of MySQL ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-general-features-connection-sharing.html
MySQL Router tracks the statements executed by the client and the SQL state of the session to ensure client connections do not lose their session state. Warnings and errors generated by statements are captured and returned when requested by the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
Explicitly defined transactions (with a START TRANSACTION or BEGIN statement) are subject to the timeout, disconnection, and incoming transaction blocking even if they do not modify any data. To allow inspection of the primary while the function is ... The following function enables you to set a member of a single-primary replication group to take over as the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-performance.html
It allows unused space within a .ibd file to be reclaimed by the OPTIMIZE TABLE statement, when substantial amounts of data are removed or indexes are dropped. MyISAM Considerations Important Although mysqlbackup backs up InnoDB tables without ...