PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...
https://dev.mysql.com/doc/refman/9.7/en/create-table.html
NOT NULL | NULL If neither NULL nor NOT NULL is specified, the column is treated as though NULL had been specified. In MySQL 9.7, only the InnoDB, MyISAM, and MEMORY storage engines support indexes on columns that can have NULL values. In other ...| ...
https://dev.mysql.com/doc/refman/9.7/en/derived-tables.html
row *************************** id: 1 select_type: PRIMARY table: <derived2> partitions: NULL type: system possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 1 filtered: 100.00 Extra: NULL *************************** 2. row ...For ...
https://dev.mysql.com/doc/refman/9.7/en/glossary.html
It provides useful information for the query optimizer, because the column is known to be not null and with unique values. A column can be subject to a unique constraint, a NOT NULL constraint, or both. See Also cardinality, foreign key, index, NOT ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. Ranges should be contiguous but not overlapping, and are defined using the ...
https://dev.mysql.com/doc/refman/9.7/en/subquery-optimization-with-exists.html
This section discusses these optimizations, particularly with regard to the challenges that NULL values present. The “pushdown” strategy just described works if either of these conditions is true: outer_expr and inner_expr cannot be NULL.
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-desc.html
ndb_desc provides a detailed description of one or more NDB tables. Usage ndb_desc -c connection_string tbl_name -d db_name [options] ndb_desc -c connection_string index_name -d db_name -t tbl_name Additional options that can be used with ndb_desc ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-schema.html
conflict_fn column The conflict resolution function to be applied; one of NDB$OLD(), NDB$MAX(), NDB$MAX_DELETE_WIN(), NDB$EPOCH(), NDB$EPOCH_TRANS(), NDB$EPOCH2(), NDB$EPOCH2_TRANS() NDB$MAX_INS(), or NDB$MAX_DEL_WIN_INS(); NULL indicates that ...
https://dev.mysql.com/doc/refman/9.7/en/json.html
A path that does not exist in the document (evaluates to nonexistent data) evaluates to NULL. $[3] evaluates to NULL (it refers to the fourth array element, which does not exist). BLOB BIT OPAQUE DATETIME TIME DATE BOOLEAN ARRAY OBJECT STRING ...The ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-metrics-table.html
Because no DML operations have been performed, the counter values are zero or NULL. row *************************** NAME: dml_inserts SUBSYSTEM: dml COUNT: 0 MAX_COUNT: 0 MIN_COUNT: NULL AVG_COUNT: 0 COUNT_RESET: 0 MAX_COUNT_RESET: 0 ... The ...