PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/is-null-optimization.html
In the following query, MySQL uses key lookups only on the expression (t1.a=t2.a AND t2.a IS NULL) and is not able to use the key part on b: SELECT * FROM t1, t2 WHERE (t1.a=t2.a AND t2.a IS NULL) OR (t1.b=t2.b AND t2.b IS NULL); . MySQL can ...
https://dev.mysql.com/doc/refman/5.7/en/known-issues.html
SELECT statements that insert zero or NULL values into an AUTO_INCREMENT column. SELECT if you have duplicate key values in the inserted data. SELECT with no ORDER BY, the SELECT may return rows in a different order (which results in a row having ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-setup.html
Choosing a Setup Type During the initial setup, you are prompted to select the MySQL products to be installed on the host. Select the Only install GA products option to restrict the product set to include GA products only when using these setup ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
--bind-address=ip_address Command-Line Format --bind-address=ip_address On a computer having multiple network interfaces, use this option to select which interface to use for connecting to the MySQL server. (For a workaround, see Section 2.11.3, ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-range-list.html
You can see that this is the case by re-running the previous SELECT query: mysql> SELECT * FROM tr WHERE purchased -> BETWEEN '1995-01-01' AND '1999-12-31'; Empty set (0.00 sec) Because of this, you must have the DROP privilege for a table before ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-pruning.html
MySQL can apply partition pruning to SELECT, DELETE, and UPDATE statements. This means that a query such as SELECT * FROM partitioned_table WHERE date_column < '2008-12-00' does not return any values (see Bug #40972). For example, this statement ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
Each row contains information about a thread and indicates whether monitoring and historical event logging are enabled for it: mysql> SELECT * FROM performance_schema.threads\G *************************** 1. row *************************** ... The ...
https://dev.mysql.com/doc/refman/5.7/en/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] SET assignment_list REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-reading.html
Suppose that a call to obtain a bookmark produces this value: mysql> SET @mark := audit_log_read_bookmark(); mysql> SELECT @mark; +-------------------------------------------------+ | @mark | +-------------------------------------------------+ | { ... The audit log plugin supports functions that provide an SQL interface for reading JSON-format audit log ...
https://dev.mysql.com/doc/refman/5.7/en/bit-value-literals.html
mysql> SELECT b+0, BIN(b), OCT(b), HEX(b) FROM t; +------+----------+--------+--------+ | b+0 | BIN(b) | OCT(b) | HEX(b) | +------+----------+--------+--------+ | 255 | 11111111 | 377 | FF | | 10 | 1010 | 12 | A | | 5 | 101 | 5 | 5 | ...A leading 0b ...