/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

1 vote350 views1 answer
Mysql month name extract
SQL
0 vote366 views1 answer
Longtext sql
SQL
0 vote374 views2 answers
How to prevent sql injection in java
SQL
0 vote366 views3 answers
Osx stop mysql service
SQL
0 vote373 views1 answer
Default order by in mysql
SQL
0 vote359 views2 answers
How covert into int in maria db
SQL
0 vote339 views1 answer
T sql return on letters only
SQL
3 votes361 views2 answers
Find string in stored procedure sql server
SQL
1 vote351 views1 answer
Set autoincrement to 0
SQL
4 votes342 views3 answers
Oracle sql first day of quarter
SQL

Share