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/partitioning-limitations.html
No InnoDB table definition may contain a foreign key reference to a user-partitioned table; no InnoDB table with user-defined partitioning may contain columns referenced by foreign keys. ORDER BY column statement run against a partitioned table ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-indexes-table.html
0 = nonunique secondary index; 1 = automatically generated clustered index (GEN_CLUST_INDEX); 2 = unique nonclustered index; 3 = clustered index; 32 = full-text index; 64 = spatial index; 128 = secondary index on a virtual generated column. The ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-expressions.html
In strict SQL mode, for INSERT into a column with an exact data type (DECIMAL or integer), a number is inserted with its exact value if it is within the column range. Inserts into numeric columns are affected by the SQL mode, which is controlled by ... With precision math, exact-value numbers are used as given whenever ...
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
The key_len column in the EXPLAIN output indicates the maximum length of the key prefix used. Equality Range Optimization of Many-Valued Comparisons Consider these expressions, where col_name is an indexed column: col_name IN(val1, ..., valN) ...
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/identifier-length.html
For constraint definitions that include no constraint name, the server internally generates a name derived from the associated table name. For example, internally generated foreign key constraint names consist of the table name plus _ibfk_ and a ...
https://dev.mysql.com/doc/refman/5.7/en/built-in-function-reference.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). The following table lists each built-in (native) function and operator and provides a short description of each one. For a ...
https://dev.mysql.com/doc/refman/5.7/en/datetime.html
In particular, any fractional part in a value inserted into a DATETIME or TIMESTAMP column is stored rather than discarded. With strict mode disabled, invalid dates such as '2004-04-31' are converted to '0000-00-00' and a warning is generated. MySQL ...This section describes their characteristics, how they are similar, and how they ...
https://dev.mysql.com/doc/refman/5.7/en/index-condition-pushdown-optimization.html
ICP is not supported with secondary indexes created on virtual generated columns. With ICP enabled, and if parts of the WHERE condition can be evaluated by using only columns from the index, the MySQL server pushes this part of the WHERE condition ... Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an ...
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 ...