/SQL/Mysql set id auto increment

Mysql set id 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

Mysql reset auto increment id

SET  @num := 0;

UPDATE your_table SET id = @num := (@num+1);

ALTER TABLE your_table AUTO_INCREMENT =1;

1

Source: stackoverflow.com

Mysql check auto increment value

SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'database_name' AND TABLE_NAME = 'table_name';

0

Similar codes

0 vote317 views2 answers
How to find sql server agent jobs related to a database
SQL
0 vote313 views1 answer
T sql check active deadlock
SQL
0 vote320 views1 answer
Sql server select value large text
SQL
5 votes302 views3 answers
Mysql check if null or empty string
SQL
0 vote289 views1 answer
Mysql earlier than date
SQL
12 votes354 views6 answers
Distinct in sql server
SQL
4 votes318 views2 answers
Convert utc to est sql
SQL
1 vote331 views1 answer
Mysql list bigger table
SQL
0 vote302 views2 answers
Find Overlapping sql
SQL
1 vote338 views1 answer
How to use db.execute
SQL

Share