/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 vote192 views1 answer
Sql server system messeges
SQL
0 vote142 views1 answer
Sql shell psql cannot enter password
SQL
5 votes149 views6 answers
In operator sql
SQL
1 vote162 views1 answer
Cannot drop database because it is currently in use
SQL
2 votes147 views1 answer
How to show the whole table in sql
SQL
0 vote147 views2 answers
Postgresql variable in query
SQL
0 vote147 views1 answer
Oracle calculate statistics on partition
SQL
36 votes140 views6 answers
Rename table sql
SQL
0 vote145 views1 answer
Plsql check how much space all databases are consuming
SQL
0 vote130 views1 answer
SQL server select to get sum of hours
SQL

Share