/SQL/Add auto_increment column to existing table mysql

Add auto_increment column to existing table mysql

Add auto_increment column to existing table mysql

ALTER TABLE `users` ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY

ALTER TABLE `users` ADD `id` INT NOT NULL AUTO_INCREMENT UNIQUE FIRST

-1

How to change the auto increment in existing table mysql

ALTER TABLE tbl_access ADD COLUMN `access_id` int(10) NOT NULL PRIMARY KEY AUTO_INCREMENT FIRST

-1

Source: stackoverflow.com

Similar codes

0 vote206 views1 answer
Connect by query in oracle
SQL
-1 vote198 views3 answers
Update mongodb version ubuntu
SQL
0 vote193 views1 answer
Access refused mysql xampp server
SQL
5 votes210 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
9 votes209 views4 answers
How to alter table column name in mysql
SQL
0 vote204 views1 answer
Sql server insert inner join
SQL
0 vote194 views1 answer
Postgresql find missing id
SQL
0 vote213 views1 answer
Mysql sum per week
SQL
2 votes212 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
1 vote188 views2 answers
Sql select only row with the max date
SQL

Share