1Alter table table_name modify column_name datatype(length) AUTO_INCREMENT PRIMARY KEY
2
1CREATE TABLE Persons (
2 Personid int NOT NULL AUTO_INCREMENT,
3 LastName varchar(255) NOT NULL,
4 FirstName varchar(255),
5 Age int,
6 PRIMARY KEY (Personid)
7);
8INSERT INTO Persons (FirstName,LastName)
9VALUES ('Lars','Monsen');