/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

4 votes165 views6 answers
Sql select statement
SQL
0 vote199 views1 answer
Mysql preg replace
SQL
0 vote175 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
1 vote219 views1 answer
Sql oracle update multiple rows
SQL
0 vote168 views4 answers
Postgresql between month
SQL
0 vote190 views1 answer
Plsql check how much space all databases are consuming
SQL
3 votes171 views2 answers
Df to sql pandas sql achemy
SQL
0 vote151 views1 answer
Output to file mysql
SQL
0 vote160 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote168 views1 answer
Why we have to set the password for my sql server
SQL

Share