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/create-view.html
For v2, 2 is replaced by a constant string expression (ordering by a constant has no effect, so ordering by any constant works). If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE VIEW. If the view does exist, CREATE OR REPLACE ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-state-table.html
The WAIT_TYPE value is a string that describes the type of wait, as shown in the following table. The TP_THREAD_STATE table has one row per thread created by the thread pool to handle connections. The TP_THREAD_STATE table has these columns: ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
The following table name aliases are used to shorten the query string: INFORMATION_SCHEMA.INNODB_SYS_TABLES: a INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES: b INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS: c An IF() control flow function is used to account ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA system ...
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. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/doc/refman/5.7/en/literals.html
These include strings, numbers, hexadecimal and bit values, boolean values, and NULL. This section describes how to write literal values in MySQL. The section also covers various nuances that you may encounter when dealing with these basic types in ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-unsupported.html
A number of features supported by other storage engines are not supported for NDB tables. Trying to use any of these features in NDB Cluster does not cause errors in or of itself; however, errors may occur in applications that expects the features ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
If the table becomes full, the Performance Schema groups statements that have SCHEMA_NAME and DIGEST values not matching existing values in the table in a special row with SCHEMA_NAME and DIGEST set to NULL. The MySQL server is capable of ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
In addition, query strings that are identical may be treated as different for other reasons. WHERE autoincrement_col IS NULL The last form is not cached because it is used as the ODBC workaround for obtaining the last insert ID value. Note The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-delayed.html
Slave_SQL_Running_State: A string indicating the state of the SQL thread (analogous to Slave_IO_State). MySQL 5.7 supports delayed replication such that a replica server deliberately lags behind the source by at least a specified amount of time.
https://dev.mysql.com/doc/refman/5.7/en/show-create-procedure.html
It returns the exact string that can be used to re-create the named stored procedure. If you do not have privileges for the routine itself, the value displayed for the Create Procedure or Create Function column is NULL. SHOW CREATE PROCEDURE ...