Search Results
https://dev.mysql.com/doc/refman/8.4/en/creating-database.html
If the administrator creates your database for you when setting up your permissions, you can begin using it. Otherwise, you need to create it yourself: mysql> CREATE DATABASE menagerie; Under Unix, database names are case-sensitive (unlike SQL ...
https://dev.mysql.com/doc/refman/8.4/en/derived-table-optimization.html
Thus, if an ER_UPDATE_TABLE_USED error occurs for a view reference that uses an expression equivalent to the subquery, adding ALGORITHM=TEMPTABLE to the view definition prevents merging and takes precedence over the derived_merge value. The ...
https://dev.mysql.com/doc/refman/8.4/en/drop-event.html
If the event does not exist, the error ERROR 1517 (HY000): Unknown event 'event_name' results. DROP EVENT [IF EXISTS] event_name This statement drops the event named event_name. The event immediately ceases being active, and is deleted completely ...
https://dev.mysql.com/doc/refman/8.4/en/drop-resource-group.html
The FORCE modifier determines statement behavior if the resource group has any threads assigned to it: If FORCE is not given and any threads are assigned to the group, an error occurs. DROP RESOURCE GROUP group_name [FORCE] DROP RESOURCE GROUP is ...
https://dev.mysql.com/doc/refman/8.4/en/drop-table.html
If any tables named in the argument list do not exist, DROP TABLE behavior depends on whether the IF EXISTS clause is given: Without IF EXISTS, the statement fails with an error indicating which nonexisting tables it was unable to drop, and no ...Be ...
https://dev.mysql.com/doc/refman/8.4/en/explain-for-connection.html
If the named connection is executing a statement that is not explainable, an error occurs. To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION ...
https://dev.mysql.com/doc/refman/8.4/en/features.html
Localization The server can provide error messages to clients in many languages. This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap applies to all versions of MySQL. Tested ...
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
ON DUPLICATE KEY UPDATE statements, but if a duplicate-key violation occurs, the statement fails with an error. Also, if the remote table is transactional, it enables the remote storage engine to perform statement rollback properly should an error ...The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-installation.html
By prefixing the option with --loose, the program does not emit an error and exit, but instead issues only a warning. To verify that, connect to the server and execute this statement: mysql> SHOW GLOBAL VARIABLES LIKE 'mysql_firewall_mode'; ...
https://dev.mysql.com/doc/refman/8.4/en/full-disk.html
This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to quota-exceeded errors (such as “write failed” or “user block limit reached”). If there is enough space, it continues as if nothing ...