How to update a column in existing records with serial numbers?

[briandunning]

I have 117,000 records in a table, and unfortunately I'm deciding "after the fact" to add a n auto_increment id column. How do I update the existing records with serial numbers?

 

[sleipnir214]

The last time I found myself in that situation, I sent the data to a file using SELECT...INTO <outfile> query, deleted all data from the table, added the auto_increment column, then reimported the data using a LOAD DATA...INFILE query.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[r937]

alter table no_auto_increment
add column id integer not null 
        primary key auto_increment first

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)