/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 vote205 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
11 votes160 views2 answers
Having clause
SQL
0 vote189 views1 answer
Sql reverse order of results
SQL
2 votes224 views1 answer
Sql compare strings
SQL
6 votes175 views1 answer
Update left join mysql
SQL
3 votes173 views4 answers
Show sql server database
SQL
4 votes180 views2 answers
Sql vs mysql
SQL
0 vote186 views1 answer
Regex mongoose
SQL
0 vote188 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
7 votes205 views2 answers
Phpmyadmin change password
SQL

Share