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/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/mysql-cluster-programs-ndb-restore.html
The following changes in primary key definitions are supported by --allow-pk-changes: Extending the primary key: A non-nullable column that exists in the table schema in the backup becomes part of the table's primary key in the database. Beginning ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
Prior to MySQL 5.7.2, this option caused any statements containing fully qualified table names not to be logged if there was no default database specified (that is, when SELECT DATABASE() returned NULL). Otherwise, if the table has a unique key all ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlslap.html
mysqlslap --delimiter=";" --number-of-queries=10 --query="use test;insert into t values(null)" --only-print Command-Line Format --only-print Type Boolean Default Value FALSE Do not connect to databases. It is always enabled and attempting to disable ... mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html
It is always enabled and attempting to disable it (--skip-secure-auth, --secure-auth=0) produces an error. <field name="column_name">NULL</field> The output when --xml is used with mysql matches that of mysqldump --xml. mysql supports the following ...
https://dev.mysql.com/doc/refman/5.7/en/datetime.html
This section describes their characteristics, how they are similar, and how they differ. MySQL recognizes DATE, DATETIME, and TIMESTAMP values in several formats, described in Section 9.1.3, “Date and Time Literals”. For the DATE and DATETIME ...
https://dev.mysql.com/doc/refman/5.7/en/connection-control-plugin-variables.html
This section describes the system and status variables that the CONNECTION_CONTROL plugin provides to enable its operation to be configured and monitored. If an account has reached the point where connection responses are delayed, a delay also ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
The rules for NULL handling are described later in this section. \Z ASCII 26 (Control+Z) \N NULL For more information about \-escape syntax, see Section 9.1.1, “String Literals”. If the FIELDS ESCAPED BY character is empty, no characters are ...
https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html
If AES_DECRYPT() detects invalid data or incorrect padding, it returns NULL. However, it is possible for AES_DECRYPT() to return a non-NULL value (possibly garbage) if the input data or the key is invalid. Note If you are using a KDF, you must ...If ...
https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html
Table 12.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...