MySQL alter table add column with primary key
  easystem   07 Juni 2018   fix error

ALTER TABLE t_data
DROP PRIMARY KEY,
ADD COLUMN id INT NOT NULL AUTO_INCREMENT FIRST,
ADD PRIMARY KEY (id);

 

if not a primary key

ALTER TABLE t_data
ADD COLUMN id INT NOT NULL AUTO_INCREMENT FIRST,
ADD PRIMARY KEY (id);

Tags :

mysql

Bagikan :