/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 vote119 views1 answer
Sql select upcoming birthdays
SQL
-1 vote128 views1 answer
Mysql change database charset and collation
SQL
6 votes125 views2 answers
Postgresql database url
SQL
2 votes148 views1 answer
Search query in mysql
SQL
0 vote115 views1 answer
Mysql where in keep order
SQL
0 vote132 views1 answer
How to inner join 4 tables in sql
SQL
3 votes123 views2 answers
Sql paging query
SQL
13 votes111 views6 answers
Mysql update from select
SQL
3 votes124 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
2 votes79 views1 answer
Sql group by different columns
SQL

Share