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/checksum-table.html
You can use this statement to verify that the contents are the same before and after a backup, rollback, or other operation that is intended to put the data back to a known state. For large tables, this could take a long time, thus you would only ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html
Generated column definitions have this syntax: col_name data_type [GENERATED ALWAYS] AS (expr) [VIRTUAL | STORED] [NOT NULL | NULL] [UNIQUE [KEY]] [[PRIMARY] KEY] [COMMENT 'string'] AS (expr) indicates that the column is generated and defines the ...
https://dev.mysql.com/doc/refman/5.7/en/creating-database.html
(Under Windows, this restriction does not apply, although you must refer to databases and tables using the same lettercase throughout a given query. Discuss this with the administrator or see Section 6.2, “Access Control and Account Management”.
https://dev.mysql.com/doc/refman/5.7/en/ddl-log.html
MySQL uses this log to recover from a crash occurring in the middle of a partitioning metadata operation. This is a binary file; it is not intended to be human-readable, and you should not attempt to modify its contents in any way. Thus, it is ...
https://dev.mysql.com/doc/refman/5.7/en/engine-condition-pushdown-optimization.html
This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. This optimization can be used only by the NDB storage engine. For example, in a my.cnf file, use these lines: [mysqld] ...In such cases, the ...
https://dev.mysql.com/doc/refman/5.7/en/function-resolution.html
This section describes how the server recognizes whether the name of a built-in function is used as a function call or as an identifier, and how the server determines which function to use in cases when functions of different types exist with a ...
https://dev.mysql.com/doc/refman/5.7/en/functions.html
This chapter describes the built-in functions and operators that are permitted for writing expressions in MySQL. This helps the MySQL parser distinguish between function calls and references to tables or columns that happen to have the same name as ... Expressions can be used at several points in SQL statements, such as in the ORDER BY or HAVING clauses of SELECT statements, in the WHERE clause of a SELECT, DELETE, or UPDATE statement, or in SET ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-distributed-recovery-basics.html
Next, the server joining the group applies the transactions that took place in the group while this state transfer was in progress. This is achieved by relying on a standard asynchronous replication channel, established between the donor and the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-lock-waits-table.html
Note This table is deprecated as of MySQL 5.7.14 and is removed in MySQL 8.0. To obtain details about the lock, join this column with the LOCK_ID column of the INNODB_LOCKS table. To obtain details about the lock, join this column with the LOCK_ID ... The INNODB_LOCK_WAITS table contains one or more rows for each blocked InnoDB transaction, indicating the lock it has requested and any locks that are blocking that ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-views-table.html
You must have the SHOW VIEW privilege to access this table. This column has most of what you see in the Create Table column that SHOW CREATE VIEW produces. Suppose that the original statement was: CREATE VIEW v AS SELECT s2,s1 FROM t WHERE s1 > 5 ...