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-restrictions.html
However, you can perform IN BOOLEAN MODE searches on the column without an index. The REGEXP and RLIKE operators work in byte-wise fashion, so they are not multibyte safe and may produce unexpected results with multibyte character sets. Identifiers ...
https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html
(For upgrades to an existing installation, perform the upgrade procedure instead; see Chapter 3, Upgrading MySQL.) However, the command that initializes the data directory does not overwrite any existing mysql schema tables, so it is safe to run in ... After MySQL is installed, the data directory must be initialized, including the tables in the mysql system schema: For some MySQL installation methods, data directory initialization is automatic, as described in Section 2.9, “Postinstallation Setup and ...
https://dev.mysql.com/doc/refman/8.0/en/load-data-local-security.html
To avoid connecting to untrusted servers, clients can establish a secure connection and verify the server identity by connecting using the --ssl-mode=VERIFY_IDENTITY option and the appropriate CA certificate. The utilities handle the file transfer ... The LOAD DATA statement loads a data file into a ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-tables.html
The replication_applier_status_by_worker table is nonempty only when the replica is operating in multithreaded mode. It refers to the master.info file used for the replica's source metadata repository, which has been superseded by the use of ...This ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
To get rid of the warning, execute an UPDATE statement to set the column to some value other than 0. CHECK TABLE Usage Notes for MyISAM Tables The following notes apply to MyISAM tables: CHECK TABLE updates key statistics for MyISAM tables. option: ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-primary-key.html
Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or foreign-key constraints. MySQL supports an IGNORE keyword for INSERT, UPDATE, and so forth. See the section for the ...If ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
Obtaining Execution Plan Information The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. If you have a problem with indexes not being used when ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-general.html
It became a bugfix series as of MySQL 8.0.34 with the introduction of the Innovation and LTS release model. For the syntax required to perform multiple-table updates, see Section 15.2.17, “UPDATE Statement”; for that required to perform ...Why ...
https://dev.mysql.com/doc/refman/8.0/en/federated-usagenotes.html
Internally, the implementation uses SELECT, INSERT, UPDATE, and DELETE, but not HANDLER. The FEDERATED storage engine supports SELECT, INSERT, UPDATE, DELETE, TRUNCATE TABLE, and indexes. ON DUPLICATE KEY UPDATE statements, but if a duplicate-key ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-foreign-table.html
0 = ON DELETE/UPDATE RESTRICT, 1 = ON DELETE CASCADE, 2 = ON DELETE SET NULL, 4 = ON UPDATE CASCADE, 8 = ON UPDATE SET NULL, 16 = ON DELETE NO ACTION, 32 = ON UPDATE NO ACTION. For related usage information and examples, see Section 17.15.3, ...