/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 vote322 views1 answer
How to open mysql in docker
SQL
0 vote355 views2 answers
Generate sql trigger through ef migration
SQL
4 votes334 views3 answers
Sql drop primary key
SQL
1 vote360 views3 answers
Epoch to datetime
SQL
0 vote320 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
12 votes381 views4 answers
How to drop all tables in postgresql
SQL
18 votes342 views3 answers
Get the list of all tables in sql server
SQL
0 vote350 views3 answers
How to verify sequence result in oracle SQL
SQL
1 vote328 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote334 views1 answer
Mysql locate
SQL

Share