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/char.html
For truncation of nonspace characters, you can cause an error to occur (rather than a warning) and suppress insertion of the value by using strict SQL mode. InnoDB encodes fixed-length fields greater than or equal to 768 bytes in length as ... The ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-coercibility.html
If both sides have the same coercibility, then: If both sides are Unicode, or both sides are not Unicode, it is an error. If one of the sides has a Unicode character set, and another side has a non-Unicode character set, the side with Unicode ... In ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-installation.html
For example, after upgrading binaries or packages from MySQL 5.7 to MySQL 8.0, attempting to restart the server with plugin-load-add=mysql_clone.so causes this error: [ERROR] [MY-013238] [Server] Error installing plugin 'clone': Cannot install ...
https://dev.mysql.com/doc/refman/8.0/en/commit.html
You cannot use ROLLBACK to undo the effect; however, if an error occurs during statement execution, the statement is rolled back. Rolling back can be a slow operation that may occur implicitly without the user having explicitly asked for it (for ...
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).