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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/signal.html
It can be an SQLSTATE value (a 5-character string literal) or a condition_name that refers to a named condition previously defined with DECLARE ... It is illegal to assign NULL to a condition information item in a SIGNAL statement. SIGNAL provides ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-analysis.html
The statement_analysis and x$statement_analysis views have these columns: query The normalized statement string. db The default database for the statement, or NULL if there is none. full_scan The total number of full table scans performed by ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-errors-or-warnings.html
The statements_with_errors_or_warnings and x$statements_with_errors_or_warnings views have these columns: query The normalized statement string. db The default database for the statement, or NULL if there is none. These views display normalized ...