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/components.html
MySQL distributions include several components that implement server extensions: Components for configuring error logging. See Section 7.4.2, “The Error Log”, and Section 7.5.3, “Error Log Components”. For example, the log_filter_dragnet ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html
CHECK constraints are evaluated for INSERT, UPDATE, REPLACE, LOAD DATA, and LOAD XML statements and an error occurs if a constraint evaluates to FALSE. If an error occurs, handling of changes already applied differs for transactional and ... Prior ...
https://dev.mysql.com/doc/refman/8.0/en/create-tablespace.html
EXTENT_SIZE: This option is specific to NDB, and is not supported by InnoDB, where it fails with an error. INITIAL_SIZE: This option is specific to NDB, and is not supported by InnoDB, where it fails with an error. CREATE TABLESPACE ts1 ...The ...
https://dev.mysql.com/doc/refman/8.0/en/drop-spatial-reference-system.html
Example: DROP SPATIAL REFERENCE SYSTEM 4120; If no SRS definition with the SRID value exists, an error occurs unless IF EXISTS is specified. If the SRID value is used by some column in an existing table, an error occurs. For example: mysql> DROP ...
https://dev.mysql.com/doc/refman/8.0/en/drop-view.html
If any views named in the argument list do not exist, the statement fails with an error indicating by name which nonexisting views it was unable to drop, and no changes are made. Note In MySQL 5.7 and earlier, DROP VIEW returns an error if any views ...Due to the change in behavior in MySQL 8.0, a partially completed DROP VIEW operation on a MySQL 5.7 replication source server fails when replicated on a MySQL 8.0 ...
https://dev.mysql.com/doc/refman/8.0/en/events-configuration.html
This causes the Event Scheduler to stop the next time it tries to execute a scheduled event, after writing a message to the server error log. No warnings or errors are generated in such cases (provided that the statements are themselves valid).
https://dev.mysql.com/doc/refman/8.0/en/fido-pluggable-authentication.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'authentication_fido'; +---------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +---------------------+---------------+ | ...
https://dev.mysql.com/doc/refman/8.0/en/grant-tables.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. Now, each statement is transactional and either succeeds for all named users or rolls back and has no effect ... The mysql system database includes several grant tables that contain information about user accounts and the privileges held by ...
https://dev.mysql.com/doc/refman/8.0/en/grant.html
GRANT either succeeds for all named users and roles or rolls back and has no effect if any error occurs. [WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ... ] ] } GRANT PROXY ON user_or_role TO user_or_role ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.html
The following discussion demonstrates functional dependence, the error message MySQL produces when functional dependence is absent, and ways of causing MySQL to accept a query in the absence of functional dependence. SQL-92 and earlier does not ...