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

Re: Adding an incremented id field

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 - Before posting, please check: http://www.mysql.com

Re: Adding an incremented id field

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 - Before posting, please check: http://www.mysql.com

Normalization advice needed

, 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 would the best method be? Gawain