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/performance-schema-file-summary-tables.html
COUNT_MISC, SUM_TIMER_MISC, MIN_TIMER_MISC, AVG_TIMER_MISC, MAX_TIMER_MISC These columns aggregate all other I/O operations, including CREATE, DELETE, OPEN, CLOSE, STREAM_OPEN, STREAM_CLOSE, SEEK, TELL, FLUSH, STAT, FSTAT, CHSIZE, RENAME, and SYNC.
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-usage.html
When the plugin reads each rule from the rules table, it computes a normalized (statement digest) form from the pattern and a digest hash value, and uses them to update the normalized_pattern and pattern_digest columns: mysql> SELECT * FROM ... To ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
Each grant table contains scope columns and privilege columns: Scope columns determine the scope of each row in the tables; that is, the context in which the row applies. Similarly, a db table row with Host, User, and Db column values of ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
--complete-insert Command-Line Format --complete-insert Write complete INSERT statements that include column names. --hex-blob Command-Line Format --hex-blob Dump binary columns using hexadecimal notation (for example, 'abc' becomes 0x616263). While ... mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions mysqlpump Object Selection mysqlpump Parallel Processing mysqlpump Restrictions The mysqlpump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. Most of the reserved words in the list are forbidden by standard SQL as column or table names (for ...This may also be true for the names of built-in ...
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. Suppose ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-range-list.html
SELECT ..., then drop the old table and rename the new one, but this could be very time-consuming when dealing with a large amounts of data. You also cannot use this statement to change the partitioning expression or column. Adding and dropping of ...
https://dev.mysql.com/doc/refman/5.7/en/insert.html
If the ON DUPLICATE KEY UPDATE clause is used and a duplicate key causes an UPDATE to be performed instead, the statement requires the UPDATE privilege for the columns to be updated. For columns that are read but not modified you need only the ...
https://dev.mysql.com/doc/refman/5.7/en/statement-caching.html
Metadata changes occur for DDL statements such as those that create, drop, alter, rename, or truncate tables, or that analyze, optimize, or repair tables. Suppose that a client prepares this statement: PREPARE s1 FROM 'SELECT * FROM t1'; The SELECT ... For certain statements that a client might execute multiple times during a session, the server converts the statement to an internal structure and caches that structure to be used during ...
https://dev.mysql.com/doc/refman/5.7/en/function-resolution.html
When the parser encounters a word that is the name of a built-in function, it must determine whether the name signifies a function call or is instead a nonexpression reference to an identifier such as a table or column name. If a new version of ...