SQL AUTO INCREMENT a Field - W3Schools Online Web Tutorials

AUTO INCREMENT a Field Very often we would like the value of the primary key field to be created automatically every time a new record is inserted. ... CREATE TABLE Persons (ID int NOT NULL AUTO_INCREMENT, LastName varchar(255) NOT NULL,

www.w3schools.com