Re: Adding an incremented id field

ightforward sql statement that will do this? > > >ALTER TABLE t_name ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY >KEY; Doh!! It does add the numbers. Sorry for the silly question and thanks again. Gawain -

Re: Adding an incremented id field

ightforward sql statement that will do this? > > >ALTER TABLE t_name ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY >KEY; Thanks for the reply. What I need is to actually add the numbers though. :-) Gawain -

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 d

Normalization advice needed

ibing these works. For instance, records 129.00 to 129.43 contain mostly the same data about the title, condition, storage, etc. with only minimal (if any) changes. My question is, is it worth the effort to normalize this data? If so, what wo