Send to a Friend

lefteh's avatar

Add an ID column to an already existing MySQL table?

Asked by lefteh (9429points) 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

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.