/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

16 votes323 views1 answer
Mssql int max value
SQL
0 vote504 views2 answers
Create new table from existing table with data in sql server
SQL
0 vote313 views1 answer
Count characters of string mysql
SQL
1 vote335 views1 answer
Setval pgsql
SQL
0 vote320 views1 answer
Select from column mysql
SQL
0 vote369 views1 answer
Mysql dump for selected row
SQL
0 vote346 views1 answer
Mysql record group by created date count
SQL
2 votes327 views2 answers
Mysql find max value row
SQL
-1 vote304 views1 answer
Io
SQL
0 vote322 views1 answer
Mysqlcli how to load external sql file
SQL

Share