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/batch-mode.html
The default output format is different (more concise) when you run mysql in batch mode than when you use it interactively. filename See Section 6.5.1.5, “Executing SQL Statements from a Text File”, for more information. In the previous ...
https://dev.mysql.com/doc/refman/8.0/en/bit-functions.html
For more information about that option, see Section 6.5.1, “mysql — The MySQL Command-Line Client”. For more information about that option, see Section 6.5.1, “mysql — The MySQL Command-Line Client”. For more information about that ...
https://dev.mysql.com/doc/refman/8.0/en/column-indexes.html
For additional information about column indexes, see Section 15.1.15, “CREATE INDEX Statement”. For example: CREATE TABLE test (blob_col BLOB, INDEX(blob_col(10))); Prefixes can be up to 767 bytes long for InnoDB tables that use the REDUNDANT or ... The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
See Section 26.6.2, “Partitioning Limitations Relating to Storage Engines”, for more information. For example, if you insert related pieces of information into several tables, do a single COMMIT after making all the changes. When you convert ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
For more information about indexes, see Section 10.3.1, “How MySQL Uses Indexes”. For more information, see Section 15.1.20.9, “Secondary Indexes and Generated Columns”. For example, a prefix can be up to 767 bytes long for InnoDB tables ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-secondary-indexes.html
The data length of logged values is limited by the index key limit of 767 bytes for COMPACT and REDUNDANT row formats, and 3072 bytes for DYNAMIC and COMPRESSED row formats. See the description of that function for more information and examples. A ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-functions.html
For more information about that option, see Section 6.5.1, “mysql — The MySQL Command-Line Client”. Example: mysql> SELECT gen_rnd_ssn(); +---------------+ | gen_rnd_ssn() | +---------------+ | 951-26-0058 | +---------------+ ...Prior to MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html
row *************************** EXPLAIN: -> Index scan on t1 using a_desc_b_asc (reverse) (cost=0.35 rows=1) See also EXPLAIN Extra Information. MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connection-protocols-ciphers.html
For background information, refer to RFC 8996 (Deprecating TLS 1.0 and TLS 1.1). For more information, see Does MySQL 8.0 support TLS 1.0 and 1.1? Connection TLS Protocol Configuration On the server side, the value of the tls_version system variable ... MySQL supports multiple TLS protocols and ciphers, and enables configuring which protocols and ciphers to permit for encrypted ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-installation.html
The legacy functions cannot handle encrypted data, public keys, and signatures created by the component functions, due to the differences in the padding and key format used by the component functions to meet the current standards. In releases ...