/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

20 votes151 views6 answers
Mysql reset auto increment
SQL
15 votes143 views2 answers
Select Options
SQL
0 vote156 views1 answer
Sql out file formate
SQL
7 votes156 views1 answer
Sql limit decimal places
SQL
0 vote153 views1 answer
How to create a table in sql stack overflow
SQL
0 vote153 views1 answer
Template MySQL Zabbix agent
SQL
1 vote156 views1 answer
Key validation sql
SQL
0 vote165 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
0 vote142 views1 answer
Mysql sql.gz
SQL
0 vote147 views1 answer
How to take sum of column with same id and different table in SQL?
SQL

Share