Search Results
https://dev.mysql.com/doc/refman/8.4/en/condition-handling.html
Handlers can be defined for general conditions such as warnings or exceptions, or for specific conditions such as a particular error code. Conditions may arise during stored program execution that require special handling, such as exiting the ...
https://dev.mysql.com/doc/refman/8.4/en/conditions-and-parameters.html
If the exception is an error, the values of OUT and INOUT parameters are not propagated back to the caller. If a stored procedure exits with an unhandled exception, modified values of OUT and INOUT parameters are not propagated back to the caller.
https://dev.mysql.com/doc/refman/8.4/en/connecting-using-uri-or-key-value-pairs.html
If a parameter is specified more than once, an error occurs. This section describes use of URI-like connection strings or key-value pairs to specify how to establish connections to the MySQL server, for clients such as MySQL Shell. For information ...
https://dev.mysql.com/doc/refman/8.4/en/connection-interfaces.html
If the server refuses a connection because the max_connections limit is reached, it increments the Connection_errors_max_connections status variable. This section describes aspects of how the MySQL server manages client connections. Network ...
https://dev.mysql.com/doc/refman/8.4/en/connection-options.html
If a client attempts to connect using these protocols, for TCP connections, the connection fails, and an error is returned to the client. This section describes options supported by most MySQL client programs that control how client programs ...
https://dev.mysql.com/doc/refman/8.4/en/create-database.html
An error occurs if the database exists and you did not specify IF NOT EXISTS. CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ... create_option: [DEFAULT] { CHARACTER SET [=] charset_name | COLLATE [=] collation_name | ENCRYPTION ...
https://dev.mysql.com/doc/refman/8.4/en/create-temporary-table.html
When innodb_strict_mode is enabled (the default), CREATE TEMPORARY TABLE returns an error if ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE is specified. You can use the TEMPORARY keyword when creating a table. A TEMPORARY table is visible only within the ...
https://dev.mysql.com/doc/refman/8.4/en/create-trigger.html
IF NOT EXISTS prevents an error from occurring if a trigger having the same name, on the same table, exists in the same schema. CREATE [DEFINER = user] TRIGGER [IF NOT EXISTS] trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW ...
https://dev.mysql.com/doc/refman/8.4/en/creating-accounts.html
For any operation that modifies a grant table, the server checks whether the table has the expected structure and produces an error if not. To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-schema.html
If the upgrade operation fails, server startup fails with an error. Data dictionary tables are protected and may only be accessed in debug builds of MySQL. However, MySQL supports access to data stored in data dictionary tables through ...