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/workbench/en/index.html
It documents the MySQL Workbench Community and MySQL Workbench Commercial releases for versions 8.0 through 8.0.46. MySQL Workbench may connect to MySQL Server 8.4 and higher but some MySQL Workbench features may not function with those later server ...
https://dev.mysql.com/doc/workbench/en/wb-configuration-additional.html
Commonly used configuration options and preferences include: Rescan for Local MySQL Instances: Right-click on the home screen, and this option will scan your system for MySQL instances and add connection tiles to the home screen. Safe Updates: When ...
https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-history.html
The Output is located at the bottom of MySQL Workbench. Its select box includes the Action Output, History Output, and Text Output options. The Action Output panel displays a summary of the communication between the active MySQL connection in MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-manage-server-connections.html
The Manage Server Connections dialog is another way to manage MySQL connections. This dialog is invoked by either clicking the manage connections icon () on the home screen or by selecting Database and then Manage Connections from the main menu. It ...