Alter table problem??

[Idee]

Hi

I need to alter a table and I am using MYSQL database. I want to add an ID column with auto increment.

ALTER TABLE tablename ADD ID INTEGER NOT NULL

In my table, there are already 80 records. What I want is that when the table is altered, the ID column should have value auto incremented from 1 to 80. With alter, I can not use Auto_Increment.

How can I achieve this?

Thanks

 

[tshot]

alter table <table name> add id integer not null auto_increment primary key;

----------------
ur feedback is a very welcome desire