Search 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-reset-connection.html
int mysql_reset_connection(MYSQL *mysql) Description Resets the connection to clear the session state. mysql_reset_connection() has effects similar to mysql_change_user() or an auto-reconnect except that the connection is not closed and reopened, ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-attr-set.html
bool mysql_stmt_attr_set(MYSQL_STMT *stmt, enum enum_stmt_attr_type option, const void *arg) Description Can be used to affect behavior for a prepared statement. This function may be called multiple times to set several options. The option argument ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-fetch.html
Each numeric and temporal type has a fixed length, as listed in the following table. Example The following example demonstrates how to fetch data from a table using mysql_stmt_result_metadata(), mysql_stmt_bind_result(), and mysql_stmt_fetch(). int ...
https://dev.mysql.com/doc/c-api/8.4/en/query-results.html
mysql_insert_id() returns the ID generated by the last query that inserted a row into a table with an AUTO_INCREMENT index. In addition to the result set returned by a query, you can also get the following information: mysql_affected_rows() returns ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-16.html
It is suitable for use with MySQL Server versions 8.0, 5.7, and 5.6. Functionality Added or Changed Bugs Fixed Functionality Added or Changed X DevAPI: Added BigInteger, BigDecimal, and Character as supported classes whose instances can be passed as ... Version 8.0.16 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
If the client connection is idle for more than a specified time, the server connection idles until a new client connection is established. and SQL_CALC_FOUND_ROWS User variables Temporary tables Prepared statements Note Transactions and LOCK TABLES ... MySQL Router enables server connections to be pooled and ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/check-instance-configuration.html
The user which you use to connect to the instance must have suitable privileges, for example as configured at Configuring InnoDB Cluster Administrator Accounts Manually. Before creating a production deployment from server instances you need to ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-switchover.html
Follow the controlled switchover procedure if the primary cluster in an InnoDB ClusterSet deployment is functioning acceptably, but you need to carry out maintenance or fix some minor issues to improve the primary cluster's function. A primary ... A ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-extension-createresult-data-specification.html
The data definition of a result is composed of the following elements: Column metadata: the column names and their types. Automatically Defined Column Data The first dictionary defined in data is used to automatically determine the column metadata.