PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-consistency-guarantees.html
You can only use the consistency levels BEFORE, AFTER and BEFORE_AND_AFTER on ONLINE members, attempting to use them on members in other states causes a session error. A transaction cannot be on-hold forever, and if the time held exceeds ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-instances.html
The use of other storage engines, including the temporary MEMORY storage engine, might cause errors in Group Replication. Set the disabled_storage_engines system variable as follows to prevent their use: ... This section explains the configuration ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
Modifying AUTO_INCREMENT column values in the middle of a sequence of INSERT statements In MySQL 5.7 and earlier, modifying an AUTO_INCREMENT column value in the middle of a sequence of INSERT statements could lead to “Duplicate entry” errors.
https://dev.mysql.com/doc/refman/8.0/en/innodb-autocommit-commit-rollback.html
By default, MySQL starts the session for each new connection with autocommit enabled, so MySQL does a commit after each SQL statement if that statement did not return an error. If a statement returns an error, the commit or rollback behavior depends ...If autocommit mode is enabled, each SQL statement forms a single transaction on its ...