/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 vote187 views1 answer
Postgres populate table from another table
SQL
0 vote247 views1 answer
Convert rows into columns in oracle
SQL
1 vote197 views1 answer
Sql random sampling per group
SQL
2 votes175 views1 answer
Mysql sysdate
SQL
0 vote224 views1 answer
How to print some string in mysql
SQL
0 vote211 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
3 votes176 views3 answers
Concatenation in sql
SQL
-1 vote185 views1 answer
Round up and down sql
SQL
0 vote234 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote184 views1 answer
Pl sql constraint user function
SQL

Share