Information Systems

How do I add an id/autoinc/primary key field to mysql? alter table table_name drop primary key; alter table table_name add id int(10) not null auto_increment primary key first;