PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-master-status.html
row *************************** File: source-bin.000002 Position: 1307 Binlog_Do_DB: test Binlog_Ignore_DB: manual, mysql Executed_Gtid_Set: 3E11FA47-71CA-11E1-9E33-C80AA9429562:1-5 1 row in set (0.00 sec) When global transaction IDs are in use, ...
https://dev.mysql.com/doc/refman/5.7/en/subqueries.html
All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. They provide alternative ways to perform operations that would otherwise require complex joins and unions. A ...Here ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs.html
Updates to the replica's applier metadata repository table are committed together with the transactions, meaning that the replica's progress information recorded in that repository is always consistent with what has been applied to the database, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-rawdata.html
If the MySQL server is still running, background tasks may still be updating the database files, particularly those involving storage engines with background processes such as InnoDB. For example, assuming that the data directory is located under ...
https://dev.mysql.com/doc/refman/5.7/en/archive-storage-engine.html
When you create an ARCHIVE table, the server creates a table format file in the database directory. The ARCHIVE engine also supports the AUTO_INCREMENT table option in CREATE TABLE statements to specify the initial sequence value for a new table or ...To examine the source for the ARCHIVE engine, look in the storage/archive directory of a MySQL source ... The ARCHIVE storage ...
https://dev.mysql.com/doc/refman/5.7/en/any-in-some-subqueries.html
When used with a subquery, the word IN is an alias for = ANY. NOT IN is not an alias for <> ANY, but for <> ALL. The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than 10. The expression is FALSE if ...
https://dev.mysql.com/doc/refman/5.7/en/case.html
[ELSE statement_list] END CASE The CASE statement for stored programs implements a complex conditional construct. This syntax cannot be used to test for equality with NULL because NULL = NULL is false. For the second syntax, each WHEN clause ...
https://dev.mysql.com/doc/refman/5.7/en/comparisons-using-subqueries.html
The most common use of a subquery is in the form: non_subquery_operand comparison_operator (subquery) Where comparison_operator is one of these operators: = > < >= <= <> != <=> For example: ... WHERE 'a' = (SELECT column1 FROM t1) MySQL also ...
https://dev.mysql.com/doc/refman/5.7/en/correlated-subqueries.html
For example: SELECT * FROM t1 WHERE column1 = ANY (SELECT column1 FROM t2 WHERE t2.column2 = t1.column2); Notice that the subquery contains a reference to a column of t1, even though the subquery's FROM clause does not mention a table t1. For ... A ...
https://dev.mysql.com/doc/refman/5.7/en/data-types.html
Consult the more detailed descriptions for additional information about particular data types, such as the permissible formats in which you can specify values. Data type descriptions use these conventions: For integer types, M indicates the maximum ... MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data ...