/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 vote360 views2 answers
Temp Space
SQL
0 vote345 views1 answer
VSCode SQL Server Connection error
SQL
0 vote366 views1 answer
Can you write relational algebra into sql queries
SQL
-1 vote329 views3 answers
Psql get last rows
SQL
0 vote338 views1 answer
Do postgresql
SQL
10 votes321 views4 answers
Primary key sql
SQL
5 votes329 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote362 views2 answers
Sql having multiple conditions
SQL
0 vote356 views1 answer
The fetch keyword oracle
SQL
0 vote366 views1 answer
Check if record exists mysql
SQL

Share