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/charset-compatibility.html
For MaxDB compatibility these two statements are the same: CREATE TABLE t1 (f1 CHAR(N) UNICODE); CREATE TABLE t1 (f1 CHAR(N) CHARACTER SET ucs2); Both the UNICODE attribute and the ucs2 character set are deprecated in MySQL 8.0.28.
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb3.html
For example: CREATE TABLE t (s1 CHAR(1)) CHARACTER SET utf8mb3; SELECT * FROM t WHERE s1 COLLATE utf8mb3_general_ci = 'x'; DECLARE x VARCHAR(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_danish_ci; SELECT CAST('a' AS CHAR CHARACTER SET utf8mb4) COLLATE ... The utf8mb3 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Requires a maximum of three bytes per multibyte ...
https://dev.mysql.com/doc/refman/8.0/en/checking-gpg-signature-windows.html
The signature file must have the same name as the packaged file but with an appended .asc extension, as shown by the example in the following table. Table 2.2 MySQL Package and Signature Files for MySQL Installer for Microsoft Windows File Type File ... The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to verify MySQL downloads using ...
https://dev.mysql.com/doc/refman/8.0/en/checking-gpg-signature.html
GnuPG is an Open Source alternative to the well-known Pretty Good Privacy (PGP) by Phil Zimmermann. Alternatively, you can copy and paste the key directly from the text below. The signature file has the same name as the distribution file with an ...
https://dev.mysql.com/doc/refman/8.0/en/cleartext-pluggable-authentication.html
Table 8.19 Plugin and Library Names for Cleartext Authentication Plugin or File Plugin or File Name Server-side plugin None, see discussion Client-side plugin mysql_clear_password Library file None (plugin is built in) Many client-side ... A ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-failure-handling.html
User-created data (schemas, tables, tablespaces) and binary logs on the recipient are removed before data is cloned to the recipient data directory. [Warning] [MY-013453] [InnoDB] Clone removing all user data for provisioning: Finished If a failure ... This section describes failure handing at different stages of a cloning ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-installation.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). This section describes how to install and configure the clone plugin. For ...
https://dev.mysql.com/doc/refman/8.0/en/communication-errors.html
The host cache, which is accessible using the Performance Schema host_cache table. See Section 7.1.12.3, “DNS Lookups and the Host Cache”, and Section 29.12.21.3, “The host_cache Table”. If connection problems occur such as communication ...
https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html
Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/8.0/en/compilation-problems.html
Versions of bison older than 1.75 may report this error: sql_yacc.yy:#####: fatal error: maximum table size (32767) exceeded The maximum table size is not actually exceeded; the error is caused by bugs in older versions of bison. If you do ...