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;