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/query-cache-operation.html
Incoming queries are compared to those in the query cache before parsing, so the following two queries are regarded as different by the query cache: SELECT * FROM tbl_name Select * from tbl_name Queries must be exactly the same (byte for byte) to be ... Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-errors.html
Incorrect number of rows from subquery: ERROR 1242 (ER_SUBSELECT_NO_1_ROW) SQLSTATE = 21000 Message = "Subquery returns more than 1 row" This error occurs for statements where the subquery must return at most one row but returns multiple rows. If ...
https://dev.mysql.com/doc/refman/5.7/en/table-locking.html
A SELECT statement that takes a long time to run prevents other sessions from updating the table in the meantime, making the other sessions appear slow or unresponsive. While a session is waiting to get exclusive access to the table for updates, ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
Example: mysql> SELECT audit_log_encryption_password_get(); +-------------------------------------+ | audit_log_encryption_password_get() | +-------------------------------------+ | secret | +-------------------------------------+ ...Unless those ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html
SELECT, the destination table does not preserve information about whether columns in the selected-from table are generated columns. The SELECT part of the statement cannot assign values to generated columns in the destination table. Values of a ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-secondary-indexes.html
row *************************** id: 1 select_type: SIMPLE table: jemp partitions: NULL type: range possible_keys: i key: i key_len: 5 ref: NULL rows: 2 filtered: 100.00 Extra: Using where 1 row in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS\G ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
(Some valid select or union statement) CREATE TABLE creates a table with the given name. [AS] query_expression To create one table from another, add a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl AS SELECT * FROM ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html
For example: mysql> GET DIAGNOSTICS CONDITION 1 @p5 = SCHEMA_NAME, @p6 = TABLE_NAME; mysql> SELECT @p5, @p6; +------+------+ | @p5 | @p6 | +------+------+ | | | +------+------+ In standard SQL, if there are multiple conditions, the first condition ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/5.7/en/handler-scope.html
One implication of the handler selection rules is that if multiple applicable handlers occur in different scopes, handlers with the most local scope take precedence over handlers in outer scopes, even over those for more specific conditions. If the ... A stored program may include handlers to be invoked when certain conditions occur within the ...
https://dev.mysql.com/doc/refman/5.7/en/index-merge-optimization.html
Here is an example of such a query: SELECT COUNT(*) FROM t1 WHERE key1 = 1 AND key2 = 1; If the used indexes do not cover all columns used in the query, full rows are retrieved only when the range conditions for all used keys are satisfied. The ...