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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-procedure.html
row *************************** Procedure: citycount sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION Create Procedure: CREATE DEFINER=`me`@`localhost` PROCEDURE ...