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/ansi-diff-foreign-keys.html
For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent rows. If ON UPDATE CASCADE or ON UPDATE SET NULL recurses to update the same table it ...
https://dev.mysql.com/doc/refman/8.0/en/char.html
The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. They also differ in maximum length and in whether trailing spaces are retained. The CHAR and VARCHAR types are declared with a length that indicates the ...
https://dev.mysql.com/doc/refman/8.0/en/charset-charsets.html
There is one subsection for each group of related character sets. To list the available character sets and their default collations, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA CHARACTER_SETS table. To avoid choosing the ...
https://dev.mysql.com/doc/refman/8.0/en/charset-errors.html
This section describes how the MySQL server uses character sets for constructing error messages. For information about the language of error messages (rather than the character set), see Section 12.12, “Setting the Error Message Language”. For ...
https://dev.mysql.com/doc/refman/8.0/en/charset-gb18030.html
In MySQL, the gb18030 character set corresponds to the “Chinese National Standard GB 18030-2005: Information technology — Chinese coded character set”, which is the official character set of the People's Republic of China (PRC).
https://dev.mysql.com/doc/refman/8.0/en/charset-metadata.html
Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is metadata. Thus column names, database names, user names, version names, and most of the string results from SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-ucs2.html
Note The ucs2 character set is deprecated in MySQL 8.0.28; expect it to be removed in a future MySQL release. In UCS-2, every character is represented by a 2-byte Unicode code with the most significant byte first. For example: LATIN CAPITAL LETTER ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html
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 MySQL 8.0.16, CREATE TABLE permits the core features of table and column CHECK ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB table. Table-level options for controlling read from any replica and partition balance can be ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-usage.html
Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 8.5.2.1, “MySQL Enterprise Data Masking and De-Identification Component Installation”. To use MySQL Enterprise Data ...