Add an ID column to an already existing MySQL table?
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
Composing members: 0