/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

14 votes149 views1 answer
Excel
SQL
10 votes140 views3 answers
Sql limit results
SQL
2 votes153 views1 answer
Mysql clear screen
SQL
0 vote150 views1 answer
Match end of string regex sql
SQL
0 vote168 views1 answer
Get relation data in mysql using query to excel
SQL
1 vote154 views3 answers
Read all columns of a table sql
SQL
1 vote172 views1 answer
Sql sort column by date
SQL
0 vote149 views1 answer
What is delimiter in mysql
SQL
0 vote148 views1 answer
Add sqlite3 in lumen
SQL
3 votes163 views4 answers
Truncate syntax in sql
SQL

Share