/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

14 votes113 views2 answers
Oracle export trigger ddl
SQL
1 vote127 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote104 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
22 votes173 views4 answers
Tsql rename table
SQL
2 votes112 views1 answer
How to get weekday from old date in sql
SQL
0 vote112 views1 answer
List in one column mysql
SQL
0 vote125 views1 answer
The fetch keyword oracle
SQL
0 vote104 views1 answer
How to read the potentail error messages in ssis package
SQL
4 votes108 views2 answers
Error loading MySQLdb module.
SQL
6 votes96 views6 answers
Count mysql
SQL

Share