General Question
Add an ID column to an already existing MySQL table?
Asked by lefteh (9434)
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.
Observing members:
0
Composing members:
0
3 Answers
Answer this question
This question is in the General Section. Responses must be helpful and on-topic.
Have a question?
Ask Fluther!