/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 vote288 views2 answers
Sql trigger difference between for and after
SQL
3 votes306 views1 answer
Only join in sql
SQL
2 votes290 views1 answer
Sql server check for value in multiple columns
SQL
1 vote299 views1 answer
Vagrant mysql downgrade version
SQL
22 votes359 views1 answer
Mysql workbench
SQL
0 vote264 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
1 vote267 views1 answer
Mysql find tables with column name
SQL
0 vote360 views1 answer
Reset a table's identity column and remove test records
SQL
14 votes289 views3 answers
Sql trim from string
SQL
0 vote279 views1 answer
Get server date mysql
SQL

Share