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/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/mysql-cluster-programs-ndb-restore.html
The following changes in primary key definitions are supported by --allow-pk-changes: Extending the primary key: A non-nullable column that exists in the table schema in the backup becomes part of the table's primary key in the database. Important ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-alter-table-performance-schema.html
stage/innodb/alter table (log apply index): This stage includes the application of DML log generated while ALTER TABLE was running. stage/innodb/alter table (log apply table): This stage includes the application of concurrent DML log generated while ... You can monitor ALTER TABLE progress for InnoDB tables using Performance ...
https://dev.mysql.com/doc/refman/5.7/en/semijoins.html
Assuming that class_num is a primary key in the class table, duplicate suppression is possible by using SELECT DISTINCT, but it is inefficient to generate all matching rows first only to eliminate duplicates later. WHERE ...); Here, ot_i and it_i ...
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
This includes the values displayed by functions such as NOW() or CURTIME(), and values stored in and retrieved from TIMESTAMP columns. Values for TIMESTAMP columns are converted from the session time zone to UTC for storage, and from UTC to the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-temp-table-info.html
The NAME column displays the system-generated name for the temporary table, which is prefixed with “#sql”. The number of columns (N_COLS) is 4 rather than 1 because InnoDB always creates three hidden table columns (DB_ROW_ID, DB_TRX_ID, and ...