/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 vote349 views1 answer
Oracle sql log to console
SQL
8 votes327 views1 answer
Sql remove characters from string right
SQL
2 votes335 views1 answer
Postgresql transaction
SQL
0 vote334 views3 answers
Mysqli count down
SQL
1 vote334 views2 answers
How to check username in mysql command line
SQL
0 vote435 views1 answer
Oracle simple quote
SQL
0 vote334 views1 answer
Sqlite3 pragma foreign keys
SQL
9 votes364 views4 answers
How to alter table column name in mysql
SQL
0 vote330 views1 answer
Sql remove first character from string
SQL
0 vote349 views1 answer
Mysql update table from select on another table
SQL

Share