/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 vote120 views1 answer
Get last run query sql server
SQL
0 vote168 views2 answers
How to find sql server agent jobs related to a database
SQL
0 vote182 views1 answer
How to start my sql server on mac
SQL
0 vote176 views1 answer
Query archive mode
SQL
4 votes181 views1 answer
W3schools create table
SQL
10 votes163 views1 answer
Oracle dependency
SQL
13 votes170 views6 answers
Current date sql
SQL
0 vote160 views1 answer
If null don't update
SQL
0 vote193 views1 answer
Automated psql csv export script on windows
SQL
3 votes178 views1 answer
How to uninstall microsoft sql server
SQL

Share