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/semijoins.html
WHERE ...); Here, ot_i and it_i represent tables in the outer and inner parts of the query, and oe_i and ie_i represent expressions that refer to columns in the outer and inner tables. Temporary table use for Duplicate Weedout is indicated by Start ... A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and ...
https://dev.mysql.com/doc/refman/5.7/en/show-warnings.html
row *************************** Level: Warning Code: 1265 Message: Data truncated for column 'b' at row 1 *************************** 2. row *************************** Level: Warning Code: 1048 Message: Column 'a' cannot be null ... SHOW WARNINGS ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-type-overview.html
MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 11.4.2, “The OpenGIS Geometry Model”. Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON ...
https://dev.mysql.com/doc/refman/5.7/en/table-scan-avoidance.html
The output from EXPLAIN shows ALL in the type column when MySQL uses a full table scan to resolve a query. There are no usable restrictions in the ON or WHERE clause for indexed columns. You are comparing indexed columns with constant values and ...
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
This includes the values displayed by functions such as NOW() or CURTIME(), and values stored in and retrieved from TIMESTAMP columns. Values for TIMESTAMP columns are converted from the session time zone to UTC for storage, and from UTC to the ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-binary-package.html
Important If you have tables that contain generated columns, use the mysqldump utility provided with MySQL 5.7.9 or higher to create your dump files. The mysqldump utility provided in earlier releases uses incorrect syntax for generated column ...
https://dev.mysql.com/doc/refman/5.7/en/where-optimization.html
If all columns in ORDER BY and GROUP BY clauses come from the same table, that table is preferred first when joining. If there is an ORDER BY clause and a different GROUP BY clause, or if the ORDER BY or GROUP BY contains columns from tables other ... This section discusses optimizations that can be made for processing WHERE ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html
As of MySQL 5.7.23, for new MySQL installations, the USER and HOST columns in the audit_log_user table used by MySQL Enterprise Audit have definitions that better correspond to the definitions of the User and Host columns in the mysql.user system ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mixed.html
When one or more tables with AUTO_INCREMENT columns are updated and a trigger or stored function is invoked. Type, binlog_format, SLC, and RLC columns outline the conditions, and Error / Warning and Logged as columns represent the corresponding ...
https://dev.mysql.com/doc/refman/5.7/en/bit-type.html
If you assign a value to a BIT(M) column that is less than M bits long, the value is padded on the left with zeros. For example, assigning a value of b'101' to a BIT(6) column is, in effect, the same as assigning b'000101'. The maximum combined size ... The BIT data type is used to store bit ...