/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 vote305 views1 answer
Alter table engine mysql
SQL
25 votes292 views1 answer
Mysql grant all privileges to a user
SQL
2 votes284 views4 answers
How to find 2nd highest salary in mysql
SQL
6 votes313 views2 answers
Mysqldump password in file
SQL
0 vote311 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
2 votes301 views2 answers
Sql percentage
SQL
1 vote300 views1 answer
Oracle stop
SQL
6 votes293 views1 answer
Phpmyadmin password root
SQL
0 vote294 views1 answer
Sql trying to delete database in use
SQL
8 votes300 views1 answer
How to remove tables from postgresql
SQL

Share