MySQL Add an auto increment column

by Dimitris | May 23, 2023 | MySQL

ALTER TABLE table ADD COLUMN id INT(10) UNSIGNED NOT NULL auto_increment PRIMARY KEY;

ή

ALTER TABLE table ADD COLUMN id INT(10) UNSIGNED NOT NULL auto_increment, ADD PRIMARY KEY (id);

ALTER TABLE table DROP COLUMN id

#unique #auto_increment