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/system-schema.html
Some system tables from before MySQL 8.0 have been replaced by data dictionary tables and are no longer present in the mysql system schema: The events data dictionary table supersedes the event table from before MySQL 8.0. Replaces the data ...It ...
https://dev.mysql.com/doc/refman/8.0/en/traceable-statements.html
Statements which are traceable are listed here: SELECT INSERT REPLACE UPDATE DELETE EXPLAIN with any of the preceding statements SET DO DECLARE, CASE, IF, and RETURN as used in stored routines CALL Tracing is supported for both INSERT and REPLACE ...For statements which are prepared and executed in separate steps, preparation and execution are traced ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html
If the ALTER USER statement does not provide the existing password in a REPLACE clause, this variable is not enforced. Whether the REPLACE clause is required is subject to the password verification policy as it applies to a given account. This ...
https://dev.mysql.com/doc/refman/8.0/en/values.html
In place of VALUES() in an INSERT or REPLACE statement, in which case its semantics differ slightly from what is described here. VALUES is a DML statement introduced in MySQL 8.0.19 which returns a set of one or more rows as a table. In other ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-usage.html
These functions permit the server's list of version tokens to be created, changed, removed, and inspected: version_tokens_set() completely replaces the current list and assigns a new list. Before using Version Tokens, install it according to the ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-choosing-id.html
If you upgrade in place, the process replaces the modified files. To add a collation, you must choose an ID value that is not currently used. The range of IDs from 1024 to 2047 is reserved for user-defined collations. The collation ID that you ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a database. If the database name is omitted, the statement applies to the default ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N BUCKETS] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [USING DATA 'json_data'] ANALYZE [NO_WRITE_TO_BINLOG ...
https://dev.mysql.com/doc/refman/8.0/en/apis-perl.html
It replaces an older interface called mysqlperl, which should be considered obsolete. The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change.
https://dev.mysql.com/doc/refman/8.0/en/archive-storage-engine.html
The ARCHIVE engine supports INSERT, REPLACE, and SELECT, but not DELETE or UPDATE. The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. To enable this storage engine if you ...