/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

1 vote278 views1 answer
Increase existing date in sql oracle
SQL
19 votes246 views1 answer
Sqrt(-1)
SQL
0 vote256 views1 answer
Postgresql parse json array
SQL
8 votes292 views3 answers
Alter user root mysql
SQL
0 vote281 views1 answer
Sqlalchemy query join many to many
SQL
1 vote283 views1 answer
Sql dcl
SQL
28 votes313 views6 answers
Sql update
SQL
6 votes301 views3 answers
How to delete table sqlite
SQL
0 vote279 views1 answer
Java sql connection
SQL
1 vote280 views1 answer
Tsql create unique index composite
SQL

Share