/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 vote154 views1 answer
Compare subqueries oracle
SQL
0 vote148 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
0 vote148 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote165 views1 answer
Set engine to innodb
SQL
7 votes164 views1 answer
Query delete duplicates
SQL
0 vote156 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote157 views1 answer
Why mysql is used?
SQL
2 votes148 views2 answers
Oracle no data found error code
SQL
0 vote362 views1 answer
Redirection 301 htaccess nom de domaine
SQL
1 vote172 views1 answer
Sql string function update replace
SQL

Share