/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

2 votes219 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote138 views1 answer
Sql truncate table referencing itself
SQL
0 vote255 views1 answer
Manage Database in MySQL
SQL
0 vote196 views1 answer
Xampp mysql version
SQL
0 vote200 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote180 views1 answer
Firebase sql
SQL
12 votes212 views1 answer
Create column sql server
SQL
0 vote228 views1 answer
Sql server datetime
SQL
0 vote184 views1 answer
Fast sql column count
SQL
2 votes181 views1 answer
Oracle virtual column
SQL

Share