PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
Setting a value greater than 29980 raises an error; setting a value less than 1 is allowed, but causes the default inline size for the column type to be used. Using any value other than 0 or 1 results in a syntax error. NDB_COLUMN Options NDB_TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/create-view.html
For example, if a view is defined as SELECT * on a table, new columns added to the table later do not become part of the view, and columns dropped from the table result in an error when selecting from the view. If, after the view has been created, a ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...
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 ...