PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/bit-value-literals.html
A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of a bit literal, use it in numeric context. For example, a bit literal assigned to a ...
https://dev.mysql.com/doc/refman/8.0/en/charset-restrictions.html
Identifiers are stored in mysql database tables (user, db, and so forth) using utf8mb3, but identifiers can contain only characters in the Basic Multilingual Plane (BMP). The ucs2, utf16, utf16le, and utf32 character sets have the following ...It ...
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-local.html
An absolute path is required, and the specified directory (“clone_dir”) must not exist, but the specified path must be an existent path. Cloning a tablespace with the same path as the source tablespace would cause a conflict and is therefore ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin.html
The plugin library contains two plugins: CONNECTION_CONTROL checks incoming connection attempts and adds a delay to server responses as necessary. This plugin also exposes system variables that enable its operation to be configured and a status ...
https://dev.mysql.com/doc/refman/8.0/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... HANDLER statement specifies a handler that deals ...
https://dev.mysql.com/doc/refman/8.0/en/drop-table.html
Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the statement removes the table definition, all its partitions, all data stored in those partitions, and all partition ...DROP TABLE causes an implicit commit, except when used with the TEMPORARY ...
https://dev.mysql.com/doc/refman/8.0/en/drop-user.html
The DROP USER statement removes one or more MySQL accounts and their privileges. Roles named in the mandatory_roles system variable value cannot be dropped. DROP USER either succeeds for all named users or rolls back and has no effect if any error ...It removes privilege rows for the account from all grant ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption.html
Note MySQL Enterprise Encryption is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition includes a set of encryption functions that expose OpenSSL capabilities at the SQL level. From MySQL 8.0.30, they ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-storage-engines.html
Is there an advantage to using the InnoDB storage engine exclusively, as opposed to a combination of InnoDB and non-InnoDB storage engines? A.2.6. That chapter contains information about all MySQL storage engines except for the InnoDB storage engine ...Where can I obtain complete documentation for MySQL storage engines? ...