create table XXX ( Name varchar(30) not null , Type varchar(20) not null, ID int not null AUTO_INCREMENT, Primary KEY (ID) );
But if you are working with Phpmyadmin, you can certainly supply these commands in the sql box. But there is also another easy way. Log into phpmyadmin as the owner of the table and click on structure. You will see every column has column definition available for you to edit. Click on change link for the column you wish to change, in this case ID column, and check on a box that has constraint A_I. Then save it. Now you are ready to roll.