79494

Further Reading

Morę information about AUTO_lNCREMENT is available here:

•    How to assign the auto_increment attribute to a column: Section 13.1.17, “CREATE TABLE

Syntax", and Section 13.1.7, “ALTER TABLE Syntax”.

•    How AUTO_lNCREMENT behaves depending on the

No_Auto_vaLue_on_ZERO [619] SQL modę:

Section 5.1.7, “Server SQL Modes”.

•    How to use the last_insert_id () [1290] function to find the rowthat contains the most recent

auto_iNCREMENT value: Section 12.14, ‘‘Information Functions”.

•    Setting the AUTO_INCREMENT value to be used: Section 5.1.4, ‘‘Server System Variables”.

•    AUTO I NCREMENT and replication: Section 16.4.1.1, “Replication and

AUTO_I NCREMENT”.

•    Server-system variables related to autoi ncrement (auto_increment_increment [2000] and

auto_increment_of fset [2003]) that can be used for replication:

Section 5.1.4, “Server System

Variables”.