/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

4 votes172 views1 answer
Rename stored procedure in sql server
SQL
0 vote126 views1 answer
Mql5 list all available symbols
SQL
0 vote139 views1 answer
How to query without duplicate rows in sql
SQL
0 vote138 views1 answer
Less than date query sqlachemy
SQL
4 votes145 views3 answers
Is not null sql
SQL
5 votes134 views3 answers
Sql make column nullable
SQL
1 vote137 views1 answer
Create new table from old table
SQL
0 vote119 views1 answer
Select value from previous row in postgresql
SQL
3 votes117 views1 answer
Difference sql vs mysql
SQL
0 vote194 views1 answer
Postgres rename database
SQL

Share