https://dev.mysql.com/charset-metadata.html
This is also true of the contents of tables in INFORMATION_SCHEMA because those tables by definition contain information about database objects. Metadata is “the data about the data.” Anything that describes the database—as opposed to being ...
https://dev.mysql.com/charset-unicode-utf16.html
The utf16 character set is the ucs2 character set with an extension that enables encoding of supplementary characters: For a BMP character, utf16 and ucs2 have identical storage characteristics: same code values, same encoding, same length. For a ...
https://dev.mysql.com/command-line-options.html
(This is also true for system variables set within option files.) For options that take a numeric value, the value can be given with a suffix of K, M, or G to indicate a multiplier of 1024, 10242 or 10243. Program options specified on the command ...
https://dev.mysql.com/connection-access.html
When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your identity and whether you can verify your identity by supplying the correct password Whether your account is locked or ...
https://dev.mysql.com/constant-folding-optimization.html
For = and <> comparisons, fold to TRUE, FALSE, or IS [NOT] NULL as described previously; for other operators, adjust the operator. Comparisons between constants and column values in which the constant value is out of range or of the wrong type with ...
https://dev.mysql.com/correlated-subqueries.html
WHERE column1 = ANY (SELECT column1 FROM t2) would be TRUE, but in this example, the WHERE clause within the subquery is FALSE (because (5,6) is not equal to (5,7)), so the expression as a whole is FALSE. A correlated subquery is a subquery that ...
https://dev.mysql.com/crashing.html
(This is not true if you are running with the delay_key_write system variable enabled, in which case data files are written but not index files.) This means that data file contents are safe even if mysqld crashes, because the operating system ...
https://dev.mysql.com/create-event.html
This is true for both CREATE EVENT and ALTER EVENT statements. CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; ...
https://dev.mysql.com/create-table-check-constraints.html
expr specifies the constraint condition as a boolean expression that must evaluate to TRUE or UNKNOWN (for NULL values) for each row of the table. Prior to MySQL 8.0.16, CREATE TABLE permits only the following limited version of table CHECK ...
https://dev.mysql.com/create-table-select.html
The same is true for other CREATE TABLE options such as CHARSET. You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new ...
