/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

12 votes176 views4 answers
How to take database dump in postgresql
SQL
3 votes199 views4 answers
Truncate syntax in sql
SQL
19 votes204 views3 answers
Grant mysql
SQL
7 votes174 views4 answers
What is my mysql version
SQL
7 votes177 views1 answer
Xampp reset mysql
SQL
1 vote199 views1 answer
Nvl postgres
SQL
0 vote156 views1 answer
Sqlite3 now
SQL
0 vote199 views1 answer
How do I insert a blob in SQL?
SQL
17 votes177 views6 answers
Current date in sql
SQL
-1 vote185 views1 answer
Default username and password for oracle 11g
SQL

Share