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>);
------------------------------------------------------------------------------------------------------------
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