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/timestamp-initialization.html
In addition, if the explicit_defaults_for_timestamp system variable is disabled, you can initialize or update any TIMESTAMP (but not DATETIME) column to the current date and time by assigning it a NULL value, unless it has been defined with the NULL ... TIMESTAMP and DATETIME columns can be automatically initializated and updated to the current date and time (that is, the current ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
Although the Oracle database allows a NULL value to be concatenated with a string, InnoDB treats the result of such an operation as NULL. It provides useful information for the query optimizer, because the column is known to be not null and with ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
The value can be NULL if the row refers to the union result of other rows. If this column is NULL (or undefined in JSON-formatted output), there are no relevant indexes. If key is NULL, MySQL found no index to use for executing the query more ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-files-table.html
The value is NULL for all data files except for predefined system tablespace data files. A NULL value for a predefined system tablespace data file indicates that a file size limit was not defined explicitly. Where no value is provided by the ... The ...
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/audit-log-file-formats.html
Valid XML characters are: #x9 | #xA | #xD | [#x20-#xD7FF] | [#xE000-#xFFFD] | [#x10000-#x10FFFF] The following elements are mandatory in every <AUDIT_RECORD> element: <NAME> A string representing the type of instruction that generated the audit ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo.html
row *************************** Engine: BLACKHOLE Support: YES Comment: /dev/null storage engine (anything you write to it disappears) Transactions: NO XA: NO Savepoints: NO *************************** 5. ndbinfo is a database containing ...
https://dev.mysql.com/doc/refman/5.7/en/nested-join-optimization.html
In some of the following examples, NULL where a table name appears means a row in which NULL is used for each column of that table. For example, t1||t2||NULL indicates a row constructed by concatenating the columns of rows t1 and t2, and NULL for ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
innodb_flush_method Command-Line Format --innodb-flush-method=value System Variable innodb_flush_method Scope Global Dynamic No Type String Default Value NULL Valid Values (Unix) fsyncO_DSYNClittlesyncnosyncO_DIRECTO_DIRECT_NO_FSYNC Valid Values ...
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 ...