Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html
SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current session.
https://dev.mysql.com/doc/refman/8.4/en/signal.html
Signals can be raised within exception handlers: CREATE PROCEDURE p () BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN SIGNAL SQLSTATE VALUE '99999' SET MESSAGE_TEXT = 'An error occurred'; END; DROP TABLE no_such_table; END; CALL p() reaches the ...SIGNAL provides error information to a handler, to an outer portion of the application, or to the ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-reference-systems.html
DROP SPATIAL REFERENCE SYSTEM: See Section 15.1.31, “DROP SPATIAL REFERENCE SYSTEM Statement”. A spatial reference system (SRS) for spatial data is a coordinate-based system for geographic locations. There are different types of spatial ...
https://dev.mysql.com/doc/refman/8.4/en/uninstall-plugin.html
The table cannot even be opened, so you cannot drop an index for which the plugin is used. If you do not care about the table, DROP TABLE can be used even if any plugins associated with the table are missing. UNINSTALL PLUGIN plugin_name This ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-troubleshooting.html
To correct this, use DROP FUNCTION to drop the loadable function, and then use CREATE FUNCTION to re-create the loadable function with a different nonconflicting name. A schema mismatch in a MySQL 8.3 instance between the .frm file of a table and ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-from-previous-series.html
When upgrading to MySQL 8.4.4 or later, it is recommended that you drop any spatial indexes beforehand, then re-create them after the upgrade is complete. Alternatively, you can drop and re-create such indexes immediately following the upgrade, but ... Before upgrading to MySQL 8.4, review the changes described in the following sections to identify those that apply to your current MySQL installation and ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-auto-reconnect.html
If the connection drops, it is possible that the session associated with the connection on the server side will still be running if the server has not yet detected that the client is no longer connected. The MySQL client library can perform an ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins-setup.html
To compile and install a plugin library file, use the instructions in Section 4.4.3, “Compiling and Installing Plugin Libraries”. To make the library file available for use, install it in the plugin directory (the directory named by the ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-conf-options.html
If adding a new session to the cache causes the number of cached sessions to exceed the defined maximum, the oldest cached session is dropped to allow the newest to be cached. If adding a new session to the cache causes the number of cached sessions ... When started, MySQL Router reads a list of configuration files that together make up the configuration of the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-privileges.html
mysql> GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%'; For more information, see Privileges Provided by MySQL and Default MySQL Privileges.