ALTER TABLE `myTable` ADD COLUMN `id` INT AUTO_INCREMENT UNIQUE FIRST NOT NULL;
On MySQL v5.5.31 this set the
id
column as the primary key for me and populated each row with an incrementing value.
0 comments:
Post a Comment