Sunday, 18 September 2016

ADD Unique/Primary ID Auto Increment at First position in MySQL

ALTER TABLE content ADD file_id INT UNSIGNED NOT NULL AUTO_INCREMENT FIRST,
ADD PRIMARY KEY (file_id);

Note : When table do not have primary key
1) FIRST ( Its means add at 1st position )
2) Table name : content
3) New Field name : file_id

------------------------------------------------------------------------------------------------------------

ALTER TABLE <TABLE NAME> ADD <FIELD NAME> INT UNSIGNED NOT NULL AUTO_INCREMENT FIRST,
ADD PRIMARY KEY (<FIELD NAME>);

------------------------------------------------------------------------------------------------------------

No comments:

Post a Comment