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/locking-service.html
The locking interface has these characteristics: Locks have three attributes: Lock namespace, lock name, and lock mode: Locks are identified by the combination of namespace and lock name. Namespace and lock names must be non-NULL, nonempty, and have ... MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...
https://dev.mysql.com/doc/refman/8.0/en/merge-storage-engine.html
The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as one. “Identical” means that all tables have identical column data types and index information. You cannot merge MyISAM ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-indexes.html
Characteristics specific to hash indexes (as used in MEMORY tables) are described in Section 10.3.9, “Comparison of B-Tree and Hash Indexes”. In this context, VARCHAR and CHAR are considered the same if they are declared as the same size. For ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
A new password-validation system variable permits the configuration and enforcement of a minimum number of characters that users must change when attempting to replace their own MySQL account passwords. This new verification setting is a percentage ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-documents-in-tables.html
In MySQL, a table may contain traditional relational data, JSON values, or both. You can combine traditional data with JSON documents by storing the documents in columns having a native JSON data type. Examples in this section use the city table in ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-in-tables.html
In MySQL, a table may contain traditional relational data, JSON values, or both. You can combine traditional data with JSON documents by storing the documents in columns having a native JSON data type. Examples in this section use the city table in ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-row-events.html
The combination of --base64-output=DECODE-ROWS and --verbose provides a convenient way to see row events only as SQL statements: $> mysqlbinlog -v --base64-output=DECODE-ROWS log_file ... Character set information is not available in the binary log, ... The following examples illustrate how mysqlbinlog displays row events that specify data ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-delimited-text.html
--fields-enclosed-by=char The character within which to enclose column values (default: no character). --fields-optionally-enclosed-by=char The character within which to enclose non-numeric column values (default: no character). But this character ... This section describes how to use mysqldump to create delimited-text dump ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-key.html
For example, the following CREATE TABLE statement is valid: CREATE TABLE tm1 ( s1 CHAR(32) PRIMARY KEY ) PARTITION BY KEY(s1) PARTITIONS 10; The preceding statement would not be valid, were a different partitioning type to be specified.
https://dev.mysql.com/doc/refman/8.0/en/show-columns.html
A UNIQUE index may display as MUL if several columns form a composite UNIQUE index; although the combination of the columns is unique, each column can still hold multiple occurrences of a given value. SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM ...