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
MATCH options do not have any other effect in MySQL, which in effect enforces MATCH SIMPLE semantics full-time. Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent.
https://dev.mysql.com/doc/refman/8.0/en/correlated-subqueries.html
A correlated subquery is a subquery that contains a reference to a table that also appears in the outer query. For example: SELECT * FROM t1 WHERE column1 = ANY (SELECT column1 FROM t2 WHERE t2.column2 = t1.column2); Notice that the subquery ...
https://dev.mysql.com/doc/refman/8.0/en/corrupted-myisam-tables.html
You are using an external program (such as myisamchk) to modify a table that is being modified by the server at the same time. Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are written before ...
https://dev.mysql.com/doc/refman/8.0/en/crashing.html
Some external program is manipulating data files or index files at the same time as mysqld without locking the table properly. Each MySQL version is tested on many platforms before it is released. This does not mean that there are no bugs in MySQL, ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...
https://dev.mysql.com/doc/refman/8.0/en/create-logfile-group.html
There can be only one log file group per NDB Cluster instance at any given time. CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html
Note Constraint expression evaluation uses the SQL mode in effect at evaluation time. Prior to MySQL 8.0.16, CREATE TABLE permits only the following limited version of table CHECK constraint syntax, which is parsed and ignored: CHECK (expr) As of ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
NDB supports deferred checks, and NO ACTION specifies a deferred check; when this is used, constraint checks are not performed until commit time. MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-generated-columns.html
If a generated column uses the TIMESTAMP data type, the setting for explicit_defaults_for_timestamp is ignored. In such cases, if this variable is disabled then NULL is not converted to CURRENT_TIMESTAMP. Note Expression evaluation uses the SQL mode ...Values of a generated column are computed from an expression included in the column ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-gipks.html
Since sql_generate_invisible_primary_key was OFF at the time that auto_0 was created, no such additions were performed on that table. Beginning with MySQL 8.0.30, MySQL supports generated invisible primary keys for any InnoDB table that is created ...