PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/en/data-dictionary-schema.html
If the upgrade operation fails, server startup fails with an error. When --no-dd-upgrade is specified, and the server finds that the data dictionary version of the server is different from the version stored in the data dictionary, startup fails ...
https://dev.mysql.com/doc/refman/8.0/en/downgrading.html
Attempting to downgrade below MySQL 8.0.35 yields an error similar to: [ERROR] [MY-013171] [InnoDB] Cannot boot server version 80034 on data directory built by version 80035. Downgrading from MySQL 8.0 to MySQL 5.7 is not supported. In-place ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/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.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/geometry-well-formedness-validity.html
Spatial import functions that parse WKT or WKB values raise an error for attempts to create a geometry that is not syntactically well-formed. Spatial computations may detect some cases of invalid geometries and raise an error, but they may also ...