Send to a Friend
Add an ID column to an already existing MySQL table?
Asked by lefteh (9429)
February 18th, 2009
This shouldn’t be so hard. I’m blaming it on my sickness and lack of sleep.
Anyway, I inherited a MySQL table, and I need to add an ID column with consecutive ID numbers. How could I go about creating this column? I need the already-existing rows to all be assigned consecutive IDs.
Using Fluther
or