Search Results
https://dev.mysql.com/doc/refman/8.4/en/reusing-ssl-sessions.html
To reconfigure the SSL session cache at runtime, use this procedure: Set each cache-related system variable that should be changed to its new value. For example, change the cache timeout value from the default (300 seconds) to 600 seconds: mysql> ...
https://dev.mysql.com/doc/refman/8.4/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. The pattern is useful for restricting statement output to matching values. Several SHOW statements also accept a WHERE clause ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-prerequisites.html
Before using the sys schema, the prerequisites described in this section must be satisfied. Because the sys schema provides an alternative means of accessing the Performance Schema, the Performance Schema must be enabled for the sys schema to work.
https://dev.mysql.com/doc/refman/8.4/en/upgrade-before-you-begin.html
Upgrade procedures vary by platform and how the initial installation was performed. Use the procedure that applies to your current MySQL installation: For binary and package-based installations on non-Windows platforms, refer to Section 3.7, ...The ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-transitioning.html
The procedure installs the component before uninstalling the plugin, to avoid having a time window during which no password validation occurs. Uninstall the validate_password plugin: UNINSTALL PLUGIN validate_password; If the validate_password ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-affected-rows.html
Following a CALL statement for a stored procedure, mysql_affected_rows() returns the value that it would return for the last statement executed within the procedure, or 0 if that statement would return -1. Within the procedure, you can use ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-insert-id.html
mysql_insert_id() returns 0 following a CALL statement for a stored procedure that generates an AUTO_INCREMENT value because in this case mysql_insert_id() applies to CALL and not the statement within the procedure. Within the procedure, you can use ... uint64_t mysql_insert_id(MYSQL *mysql) Description Returns the value generated for an AUTO_INCREMENT column by the previous INSERT or UPDATE ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-next-result.html
mysql_next_result() is used when you execute multiple statements specified as a single statement string, or when you use CALL statements to execute stored procedures, which can return multiple result sets. If your program uses CALL statements to ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-connect.html
CLIENT_MULTI_RESULTS: Tell the server that the client can handle multiple result sets from multiple-statement executions or stored procedures. If your program uses CALL statements to execute stored procedures, the CLIENT_MULTI_RESULTS flag must be ... MYSQL * mysql_real_connect(MYSQL *mysql, const char *host, const char *user, const char *passwd, const char *db, unsigned int port, const char *unix_socket, unsigned long client_flag) Description Note mysql_real_connect() is a synchronous ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-4-0.html
(Bug #22473405) DatabaseMetadata.getProcedureColumns() and DatabaseMetadata.getFunctionColumns() returned incorrect information when the procedure or function column names include whitespace characters. (Bug #21294134) ... Note These release notes ...