Re: Adding an incremented id field

At 12:04 PM -0600 on 12/29/01, Sherzod Ruzmetov aka sherzodR wrote: > : I've got a database already populated with data and need to add a > : sequential numerical "id" field as a key. (as one would with an auto > : increment field) > : > : Is there a straightforward sql statement that

Re: Adding an incremented id field

At 12:04 PM -0600 on 12/29/01, Sherzod Ruzmetov aka sherzodR wrote: > : I've got a database already populated with data and need to add a > : sequential numerical "id" field as a key. (as one would with an auto > : increment field) > : > : Is there a straightforward sql statement that

Re: Adding an incremented id field

: I've got a database already populated with data and need to add a : sequential numerical "id" field as a key. (as one would with an auto : increment field) : : Is there a straightforward sql statement that will do this? ALTER TABLE t_name ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT

Adding an incremented id field

I've got a database already populated with data and need to add a sequential numerical "id" field as a key. (as one would with an auto increment field) Is there a straightforward sql statement that will do this? Gawain - Befo