PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
Additionally: A server restart no longer cancels the effect of the AUTO_INCREMENT = N table option. If you modify an AUTO_INCREMENT column value to a value larger than the current maximum auto-increment value (in an UPDATE operation, for example), ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/insert.html
Because AUTO_INCREMENT values are generated after other value assignments, any reference to an AUTO_INCREMENT column in the assignment returns a 0. For INSERT examples involving AUTO_INCREMENT column values, see Section 5.6.9, “Using ... INSERT ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
To reset the current auto-increment value: ALTER TABLE t1 AUTO_INCREMENT = 13; You cannot reset the counter to a value less than or equal to the value that is currently in use. For both InnoDB and MyISAM, if the value is less than or equal to the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-selection.html
Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is supported. Partition selection is similar to partition pruning, in that only specific partitions are checked for matches, but differs in two key ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
Some problems reported by CHECK TABLE cannot be corrected automatically: Found row where the auto_increment column has the value 0. This means that you have a row in the table where the AUTO_INCREMENT index column contains the value 0. In this case, ...option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...
https://dev.mysql.com/doc/refman/8.0/en/delete.html
Auto-Increment Columns If you delete the row containing the maximum value for an AUTO_INCREMENT column, the value is not reused for a MyISAM or InnoDB table. There are some exceptions to this behavior for InnoDB tables, as discussed in Section ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-fulltext-index.html
If you want to create your own FTS_DOC_ID column, the column must be defined as BIGINT UNSIGNED NOT NULL and named FTS_DOC_ID (all uppercase), as in the following example: Note The FTS_DOC_ID column does not need to be defined as an AUTO_INCREMENT ... Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
When rows are inserted in sorted order (as when you are using an AUTO_INCREMENT column), the index tree is split so that the high node only contains one key. (When an AUTO_INCREMENT column is defined as the last column of a multiple-column index, ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of ...