/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 vote133 views1 answer
Price-colour
SQL
2 votes173 views6 answers
In operator in sql
SQL
1 vote133 views2 answers
Mysql: command not found
SQL
1 vote113 views1 answer
Sql convert month name to number
SQL
11 votes154 views3 answers
Sql line numbers
SQL
0 vote147 views2 answers
Dumping sql table
SQL
2 votes100 views1 answer
Latest record in sql
SQL
0 vote151 views2 answers
Collation in sql
SQL
5 votes143 views4 answers
Upload database mysql command line
SQL
2 votes138 views1 answer
Mysql Incorrect column specifier for column
SQL

Share