/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 vote101 views1 answer
Mysql earlier than date
SQL
0 vote107 views2 answers
Sql day from datetime
SQL
0 vote129 views2 answers
PostgreSQL having
SQL
7 votes136 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
3 votes137 views1 answer
Oracle function
SQL
0 vote118 views1 answer
Find wordpress version in database
SQL
-1 vote117 views1 answer
Concat two columns in sql server
SQL
0 vote138 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote116 views1 answer
Postgresql custom order by
SQL
0 vote106 views1 answer
Pgsql is not permitted to log in
SQL

Share