PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/charset-unicode-utf8mb3.html
In MySQL 8.0.30 and later, the reverse is true, so that in statements such as SHOW CREATE TABLE or SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLUMNS or SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLUMNS, users see the character set or ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/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 it by supplying the proper credentials. A failure at either step causes the server to ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/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 ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
(It is recommended but not required that --ssl-ca also be specified so that the public certificate provided by the server can be verified.) This is true for ISSUER and SUBJECT as well because those REQUIRE options imply the requirements of X509.