PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-attributes.html
If you store values larger than the display width in an integer column that has the ZEROFILL attribute, you may experience problems when MySQL generates temporary tables for some complicated joins. Inserting NULL to generate AUTO_INCREMENT values ...
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
For more information, see Section 13.1.18.8, “Secondary Indexes and Generated Columns”. For example (col1, col2, col3) specifies a multiple-column index with index keys consisting of values from col1, col2, and col3. Additionally, BLOB and TEXT ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/doc/refman/5.7/en/view-updatability.html
For information about generated columns, see Section 13.1.18.7, “CREATE TABLE and Generated Columns”. However, if such a column is updated explicitly, the only permitted value is DEFAULT. Also, only a single table in the view definition can be ... Some views are updatable and references to them can be used to specify tables to be updated in data change ...
https://dev.mysql.com/doc/refman/5.7/en/replace.html
If a generated column is replaced explicitly, the only permitted value is DEFAULT. For information about generated columns, see Section 13.1.18.7, “CREATE TABLE and Generated Columns”. The server recognizes but ignores the DELAYED keyword, ...
https://dev.mysql.com/doc/refman/5.7/en/check-table.html
CHECK TABLE supports secondary indexes on virtual generated columns, which are supported by InnoDB. CHECK TABLE Output Checking Version Compatibility Checking Data Consistency CHECK TABLE Usage Notes for InnoDB Tables CHECK TABLE Usage Notes for ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-binary-package.html
Important If you have tables that contain generated columns, use the mysqldump utility provided with MySQL 5.7.9 or higher to create your dump files. The mysqldump utility provided in earlier releases uses incorrect syntax for generated column ...
https://dev.mysql.com/doc/refman/5.7/en/update.html
If a generated column is updated explicitly, the only permitted value is DEFAULT. For information about generated columns, see Section 13.1.18.7, “CREATE TABLE and Generated Columns”. Multiple-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mixed.html
When one or more tables with AUTO_INCREMENT columns are updated and a trigger or stored function is invoked. Like all other unsafe statements, this generates a warning if binlog_format = STATEMENT. (Bug #39701) Note A warning is generated if you try ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a DML statement updates an NDBCLUSTER ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-6.html
Memory required for indexes on NDB table columns is now allocated dynamically from that allocated for DataMemory. In addition, data nodes now generate MemoryUsage events (see Section 21.6.3.2, “NDB Cluster Log Events”) and write appropriate ...
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 ...