[mysql] How to create a IDENTITY column in MySQL?

create TABLE Table1
(
        ID int AUTO_INCREMENT  PRIMARY KEY,  
        classid int,
        sex varchar(10),
        age int
     
 )

ID 會自動加1且是PRIMARY KEY

AUTO_INCREMENT 相當於 IDENTITY (1,1)