briandunning
Technical User
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?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to update a column in existing records with serial numbers?
- Thread starter briandunning
- Start date
- Status
sleipnir214
Programmer
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!!
Want the best answers? Ask the best questions!
TANSTAAFL!!
Code:
alter table no_auto_increment
add column id integer not null
primary key auto_increment firstrudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)
- Status
Similar threads
- Locked
- Question