/SQL/Reset auto increment in MySQL

Reset auto increment in MySQL

Mysql reset auto increment value

ALTER TABLE table_name AUTO_INCREMENT = 1;

16

Mysql reset auto increment

ALTER TABLE `Table Name` AUTO_INCREMENT = 1;

2

Reset auto increment in MySQL

ALTER TABLE tablename AUTO_INCREMENT = 1

1

Source: stackoverflow.com

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

Similar codes

0 vote307 views1 answer
Mysql extract day from date leading zero
SQL
1 vote274 views1 answer
Select not matching data from two tables
SQL
0 vote294 views1 answer
Running query in redshift
SQL
4 votes289 views2 answers
Insert current date in mysql
SQL
0 vote298 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
22 votes330 views4 answers
Date format mysql
SQL
0 vote285 views2 answers
Sql regex vowel
SQL
0 vote283 views1 answer
How to find database collation in postgres
SQL
3 votes295 views3 answers
C# sql select
SQL
11 votes320 views1 answer
Ddl view
SQL

Share