/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 vote121 views1 answer
Timestamp(0) postgresql
SQL
1 vote146 views3 answers
Connection string mysql
SQL
1 vote127 views1 answer
Sql group by error
SQL
2 votes145 views1 answer
Install postgresql centos 5
SQL
0 vote133 views2 answers
Mysql select date from datetime
SQL
7 votes125 views3 answers
Sql get last inserted row
SQL
0 vote139 views1 answer
Postgressql uuid
SQL
2 votes79 views1 answer
Select sid oracle
SQL
3 votes121 views1 answer
Oracle APEX elapsed time
SQL
1 vote126 views1 answer
ORA-01950
SQL

Share