/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 vote153 views2 answers
Disallowed function mysql to_date()
SQL
-2 votes203 views1 answer
Trunc in sql
SQL
58 votes361 views6 answers
Create new user in postgres
SQL
2 votes158 views1 answer
Sql finding longest and shortest names in a fleld
SQL
1 vote160 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote159 views1 answer
How to locate pg_hba.conf file
SQL
26 votes150 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote150 views1 answer
Mysql to get column name in database
SQL
10 votes159 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote530 views1 answer
How to connect .sql data set to powerbi
SQL

Share