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/innodb-auto-increment-handling.html
InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT columns. To use the AUTO_INCREMENT mechanism with an InnoDB table, an ...The ...
https://dev.mysql.com/doc/refman/8.0/en/example-auto-increment.html
For example: INSERT INTO animals (id,name) VALUES(NULL,'squirrel'); When you insert any other value into an AUTO_INCREMENT column, the column is set to that value and the sequence is reset so that the next automatically generated value follows ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-auto-increment.html
Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated ...This occurs because the order in which the rows are numbered depends on the specific storage engine used for the table and the order in which the rows were ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
Using AUTO_INCREMENT with FLOAT or DOUBLE columns is deprecated as of MySQL 8.0.17; expect support for it to be removed in a future version of MySQL. AUTO_INCREMENT An integer or floating-point column can have the additional attribute AUTO_INCREMENT. When you insert a value of NULL (recommended) or 0 into an indexed AUTO_INCREMENT column, the column is set to the next sequence ...
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
LAST_INSERT_ID(), LAST_INSERT_ID(expr) With no argument, LAST_INSERT_ID() returns a BIGINT UNSIGNED (64-bit) value representing the first automatically generated value successfully inserted for an AUTO_INCREMENT column as a result of the most ...It ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-examples.html
For MyISAM tables, you can set the first sequence number by executing SET INSERT_ID=value before ALTER TABLE or by using the AUTO_INCREMENT=value table option. With MyISAM tables, if you do not change the AUTO_INCREMENT column, the sequence number ...For NDB tables, it is also possible to change the storage type used for a table or ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-source.html
Attempting to set the value of auto_increment_increment or auto_increment_offset to a noninteger value produces an error, and the actual value of the variable remains unchanged. When Group Replication is started on a server, the value of ... This ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-syntax.html
Like other MySQL storage engines, the NDB storage engine can handle a maximum of one AUTO_INCREMENT column per table, and this column must be indexed. However, in the case of an NDB table with no explicit primary key, an AUTO_INCREMENT column is ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html
When you insert a value of NULL into an indexed AUTO_INCREMENT column, the column is set to the next sequence value. (AUTO_INCREMENT sequences begin with 1.) Storing 0 into an AUTO_INCREMENT column has the same effect as storing NULL, unless the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-desc.html
Table 25.31 Command-line options used with the program ndb_desc Format Description Added, Deprecated, or Removed --auto-inc, -a Show next value for AUTO_INCREMENT oolumn if table has one ADDED: NDB 8.0.21 --blob-info, -b Include partition ...