/SQL/Alter table auto_increment

Alter table auto_increment

Mysql set id auto increment

ALTER TABLE users AUTO_INCREMENT=1001;

6

Source: stackoverflow.com

Auto_increment mysql

ALTER TABLE User AUTO_INCREMENT = 1;

2

Alter table auto_increment

ALTER TABLE ALLITEMS CHANGE itemid itemid INT(10)AUTO_INCREMENT PRIMARY KEY;

0

Source: stackoverflow.com

Similar codes

0 vote291 views1 answer
Mysql disable triggers
SQL
10 votes288 views2 answers
Sql pagination offset
SQL
1 vote252 views4 answers
Fatal database postgres does not exist
SQL
0 vote290 views1 answer
Select sql in descending order
SQL
4 votes283 views1 answer
Mysql ip address data type
SQL
2 votes298 views1 answer
Oracle insert or update
SQL
1 vote265 views1 answer
Mysql sort by date column
SQL
0 vote260 views1 answer
Mysql into outfile with headers
SQL
1 vote276 views1 answer
Is sql fast
SQL
2 votes279 views4 answers
2nd highest salary in mysql
SQL

Share