/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

23 votes361 views2 answers
Query to delete a database in mysql
SQL
0 vote336 views1 answer
What is the essence of SQL?
SQL
0 vote340 views1 answer
Denormalise SQL command
SQL
7 votes365 views5 answers
Show details of table postgres
SQL
0 vote357 views1 answer
How many rows affected in sqllite
SQL
0 vote358 views4 answers
Forenkey code alchemy sql
SQL
4 votes358 views1 answer
Sql any
SQL
1 vote332 views2 answers
Sql where is not number
SQL
1 vote346 views1 answer
Calculate age in sql postgresql
SQL
0 vote386 views1 answer
How to pass list as parameter in SQL query
SQL

Share