Re: Adding Customer ID numbers to and already existing table

If v.3.23+, it's a one-step, along the lines of: ALTER TABLE tablename ADD columnname INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT = 1000 Prior to 3.23, it's a three-step: 1st, alter the table to include the key: ALTER TABLE tablename ADD columnname INT UNSIGNED NOT NULL PRIMARY KEY AUTO_I

Adding Customer ID numbers to and already existing table

How would I add customer id numbers which start at 1000 to an already existing table. I need these numbers to auto_increment. Any help would be great Armando - Before posting, please check: http://www.mysql.com/manual.php