Difficulty
Last Reviewed
Notes
Reference Link
Reviewed
Status
Done
Tags
(show you how to use an AUTO_INCREMENT column to generate unique numbers automatically for the primary key)
Introduction to MySQL AUTO_INCREMENT attribute
In MySQL, you use the AUTO_INCREMENT attribute to automatically generate unique integer values for a column whenever you insert a new row into the table. Typically, you use the AUTO_INCREMENT attribute for the primary key column to ensure each row has a unique identifier.
‣
Creating a table with MySQL AUTO_INCREMENT column
‣
Inserting rows with AUTO_INCREMENT column
‣
Retrieving the last auto-increment value
‣
Resetting the current auto-increment value
‣