/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 vote222 views2 answers
Postgres show current role
SQL
0 vote234 views1 answer
Savepoint mysql script
SQL
19 votes198 views6 answers
Laravel sql query
SQL
0 vote227 views1 answer
How to get data from 2 database
SQL
0 vote213 views1 answer
Oracle step procedure
SQL
0 vote210 views1 answer
Mysql find db contarint
SQL
15 votes211 views4 answers
Pl sql
SQL
0 vote220 views1 answer
Java check if something is in mysql table
SQL
1 vote216 views1 answer
Sql convert month name to number
SQL
7 votes237 views3 answers
Postgresql dump and restore db
SQL

Share