/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

25 votes119 views1 answer
Mysql grant all privileges to a user
SQL
0 vote150 views1 answer
How to fetch data from database in sql
SQL
1 vote130 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
3 votes123 views2 answers
Find the median in sql
SQL
0 vote156 views1 answer
Select * where id = 1,2,3
SQL
0 vote160 views1 answer
Offset in postgresql example
SQL
1 vote133 views1 answer
Type int in mysql maxlenght
SQL
0 vote158 views1 answer
Sql declare variable single line
SQL
3 votes133 views1 answer
Sql is not like
SQL
1 vote118 views1 answer
Sql alchemy with azuresql server
SQL

Share