PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/en/create-table.html
When you insert a value of NULL (recommended) or 0 into an indexed AUTO_INCREMENT column, the column is set to the next sequence value. To retrieve an AUTO_INCREMENT value after inserting a row, use the LAST_INSERT_ID() SQL function or the ...| ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/jdv-requirements.html
Requirements and Restrictions for Primary Key Columns During insert operations, it is possible to use generated values for primary key columns and other base table columns that have the AUTO_INCREMENT attribute. The JSON document can omit the join ... Review the following requirements and restrictions for table annotations and DML operations on JSON duality ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-source.html
Attempting to set the value of auto_increment_increment or auto_increment_offset to a non-integer 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/9.7/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/9.7/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 ...