PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.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 ... A derived ...
https://dev.mysql.com/doc/refman/5.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/5.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 5.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/5.7/en/json.html
(When the server is manipulating a JSON value internally in memory, it can be larger than this; the limit applies when the server stores it.) A JSON column cannot have a non-NULL default value. A path that does not exist in the document (evaluates ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html
This section discusses these optimizations, particularly with regard to the challenges that NULL values present. That is, the “pushdown” strategy works as long as both of these conditions are true: outer_expr and inner_expr cannot be NULL.
https://dev.mysql.com/doc/refman/5.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/5.7/en/innodb-parameters.html
daemon_memcached_engine_lib_path Command-Line Format --daemon-memcached-engine-lib-path=dir_name System Variable daemon_memcached_engine_lib_path Scope Global Dynamic No Type Directory name Default Value NULL The path of the directory containing the ... System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/5.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/5.7/en/mysql-cluster-replication-schema.html
Note When performing schema changes on NDB tables, applications should wait until the ALTER TABLE statement has returned in the MySQL client connection that issued the statement before attempting to use the updated definition of the table.
https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html
All members of the second object which do not have a corresponding key in the first object, and whose value is not the JSON null literal. All members with a key that exists in both the first and the second object, and whose value in the second ...