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/constraint-foreign-key.html
SET DEFAULT is also supported by the MySQL Server but is currently rejected as invalid by InnoDB. Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent. The available ...MySQL supports ON UPDATE and ON DELETE foreign key references in CREATE TABLE and ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/semijoins.html
It must not contain any aggregate functions (whether it is explicitly or implicitly grouped). The statement must not use the STRAIGHT_JOIN join type in the outer query. The number of outer and inner tables together must be less than the maximum ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-examples.html
If it is important to have the same order on the source and replica, the rows must be ordered before assigning an AUTO_INCREMENT number. For NDB tables, it is also possible to change the storage type used for a table or column. row ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-restrictions.html
This is because stored routine and trigger definitions are stored in tables in the mysql system database using InnoDB tables, which are not copied between Cluster nodes. If you refer to a temporary table multiple times in a stored function under ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-concepts.html
A GTID transaction can be addressed either by its GTID, or by the name of the file in which it is logged and its position within that file. Before setting the replication mode of an online server, it is important to understand some key concepts of ...An anonymous transaction has no GTID; MySQL 8.0 ensures that every anonymous transaction in a log is preceded by an ...
https://dev.mysql.com/doc/refman/8.0/en/constraints.html
We must handle the case when you have inserted or updated a lot of rows in a nontransactional table for which changes cannot be rolled back when an error occurs. Several SQL mode options are available to provide greater control over handling of bad ...The basic philosophy is that MySQL Server tries to produce an error for anything that it can detect while parsing a statement to be executed, and tries to recover from any errors that occur while executing the ...
https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html
If column aliases are not used, or if they are the same as the column names, they must be distinguished using the row alias in the ON DUPLICATE KEY UPDATE clause. Column aliases must be unique with regard to the row alias to which they apply (that ... If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row ...
https://dev.mysql.com/doc/refman/8.0/en/identifiers.html
Special characters in database and table names are encoded in the corresponding file system names as described in Section 11.2.4, “Mapping of Identifiers to File Names”. Certain objects within MySQL, including database, table, index, column, ...
https://dev.mysql.com/doc/refman/8.0/en/lock-instance-for-backup.html
Operations that modify InnoDB files that are not recorded in the InnoDB redo log are also blocked. PURGE BINARY LOGS should not be issued while a LOCK INSTANCE FOR BACKUP statement is in effect for the instance, because it contravenes the rules of ...Executing the LOCK INSTANCE FOR BACKUP statement requires the BACKUP_ADMIN ... LOCK INSTANCE FOR BACKUP UNLOCK INSTANCE LOCK INSTANCE FOR BACKUP acquires an instance-level backup lock that permits DML during an online ...
https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-columns.html
Columns with a spatial data type can have an SRID attribute, to explicitly indicate the spatial reference system (SRS) for values stored in the column. Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE tables. See also the notes ...