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/nested-join-optimization.html
The following discussion refers to the join syntax described in Section 13.2.9.2, “JOIN Clause”. The syntax of table_factor is extended in comparison with the SQL Standard. The latter accepts only table_reference, not a list of them inside a ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-attributes.html
When used in conjunction with the optional (nonstandard) ZEROFILL attribute, the default padding of spaces is replaced with zeros. MySQL supports an extension for optionally specifying the display width of integer data types in parentheses ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-pruning.html
In many cases, the equal sign can be replaced with another arithmetic comparison, including <, >, <=, >=, and <>. The core concept behind partition pruning is relatively simple, and can be described as “Do not scan partitions where there can be no ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-variable-table-migration.html
The Performance Schema tables are intended to replace the INFORMATION_SCHEMA tables, which are deprecated as of MySQL 5.7.6 and are removed in MySQL 8.0. The INFORMATION_SCHEMA has tables that contain system and status variable information (see ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-triggers.html
The effect for this trigger is thus the same as the multiple triggers it replaces. With statement-based replication, triggers executed on the source also execute on the replica. With row-based replication, triggers executed on the source do not ...
https://dev.mysql.com/doc/refman/5.7/en/resignal.html
(The reason the condition adds to rather than replaces the existing condition is the use of a condition value.) The RESIGNAL statement includes a condition value (SQLSTATE '45000'), so it adds a new condition area, resulting in a diagnostics area ...
https://dev.mysql.com/doc/refman/5.7/en/se-csv-repair.html
The CSV storage engine supports the CHECK TABLE and REPAIR TABLE statements to verify and, if possible, repair a damaged CSV table. When running the CHECK TABLE statement, the CSV file is checked for validity by looking for the correct field ...
https://dev.mysql.com/doc/refman/5.7/en/signal.html
The message text and error number set by the warning are replaced by the values set by the error, which are returned with the error information. SIGNAL provides error information to a handler, to an outer portion of the application, or to the client. Also, it provides control over the error's characteristics (error number, SQLSTATE value, ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
The CMake program provides a great deal of control over how you configure a MySQL source distribution. Typically, you do this using options on the CMake command line. For information about options supported by CMake, run either of these commands in ...
https://dev.mysql.com/doc/refman/5.7/en/subqueries.html
This applies to statements such as DELETE, INSERT, REPLACE, UPDATE, and (because subqueries can be used in the SET clause) LOAD DATA. All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are ...