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/partitioning-handling-nulls.html
NULL is handled somewhat differently for tables partitioned by HASH or KEY. For tables that are partitioned by HASH or KEY, this result is treated for determining the correct partition as 0. Partitioning in MySQL does nothing to disallow NULL as ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-maintenance.html
Example: ALTER TABLE t1 REPAIR PARTITION p0,p1; Normally, REPAIR PARTITION fails when the partition contains duplicate key errors. You can use ALTER IGNORE TABLE with this option, in which case all rows that cannot be moved due to the presence of ...
https://dev.mysql.com/doc/refman/8.0/en/rename-table.html
RENAME TABLE tbl_name TO new_tbl_name changes internally generated foreign key constraint names and user-defined foreign key constraint names that begin with the string “tbl_name_ibfk_” to reflect the new table name. InnoDB interprets foreign ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-names.html
UCA-based collations without a version number in the name use the version-4.0.0 UCA weight keys. For example: utf8mb4_0900_ai_ci is based on UCA 9.0.0 weight keys (http://www.unicode.org/Public/UCA/9.0.0/allkeys.txt). utf8mb4_unicode_ci (with no ...
https://dev.mysql.com/doc/refman/8.0/en/document-store-concepts.html
JSON Document Collection CRUD Operations JSON Document A JSON document is a data structure composed of key-value pairs and is the fundamental structure for using MySQL as document store. Mogae", "GovernmentForm": "Republic" }, "demographics": { ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connection-protocols-ciphers.html
The negotiation process depends on factors such as the SSL library used to compile the server and client, the TLS protocol and encryption cipher configuration, and which key size is used: For a connection attempt to succeed, the server and client ...
https://dev.mysql.com/doc/refman/8.0/en/grant-tables.html
The attribute value is an array of elements that each have Database and Restrictions keys indicating the name of a restricted database and the applicable restrictions on it (see Section 8.2.12, “Privilege Restriction Using Partial Revokes”). The ... The mysql system database includes several grant tables that contain information about user accounts and the privileges held by ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-config-table.html
The INNODB_FT_CONFIG table has these columns: KEY The name designating an item of metadata for an InnoDB table containing a FULLTEXT index. The key names and their meanings include: optimize_checkpoint_limit: The number of seconds after which an ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-partitions-table.html
PARTITION_METHOD One of the values RANGE, LIST, HASH, LINEAR HASH, KEY, or LINEAR KEY; that is, one of the available partitioning types as discussed in Section 26.2, “Partitioning Types”. SUBPARTITION_METHOD One of the values HASH, LINEAR HASH, ...Each row in this table corresponds to an individual partition or subpartition of a partitioned ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-isolation-levels.html
For other search conditions, InnoDB locks the index range scanned, using gap locks or next-key locks to block insertions by other sessions into the gaps covered by the range. For information about gap locks and next-key locks, see Section 17.7.1, ...