/SQL/Mysql change auto_increment start value

Mysql change auto_increment start value

Mysql change auto_increment start value

ALTER TABLE users AUTO_INCREMENT=1001;

6

Source: stackoverflow.com

Change auto increment mysql

ALTER TABLE tbname MODIFY COLUMN columname smallint(5) auto_increment

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 vote359 views1 answer
Postgresql like
SQL
6 votes351 views3 answers
Mysql create database utf8
SQL
0 vote318 views1 answer
Sql where time stamp is in between
SQL
1 vote334 views2 answers
Sql drop multiple columns if exists
SQL
0 vote347 views1 answer
Sqlalchemy get schema from database
SQL
2 votes397 views1 answer
Install postgresql centos 5
SQL
0 vote331 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
13 votes306 views3 answers
Uninstall mysql centos 7
SQL
7 votes350 views3 answers
Postgresql dump and restore db
SQL
0 vote308 views1 answer
Strat with in sql
SQL

Share