Search Results
https://dev.mysql.com/doc/refman/8.4/en/explain.html
In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a query). There is no need to enclose the ...The following discussion uses the DESCRIBE and EXPLAIN keywords in accordance with those uses, but the MySQL parser treats them as completely ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4/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.4/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.4/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.4/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 ...