/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

4 votes143 views2 answers
Bulk kill mysql processlist
SQL
0 vote140 views1 answer
Sql put two columns into one
SQL
0 vote141 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
9 votes131 views4 answers
Mysql show table fields
SQL
1 vote132 views1 answer
Replace all numbers in mysql
SQL
0 vote132 views1 answer
How to check replication lag in mySQL
SQL
0 vote126 views1 answer
Online sql testing tool
SQL
0 vote169 views1 answer
Migrations.RunSQL
SQL
5 votes125 views4 answers
Describe table postgres
SQL
0 vote135 views1 answer
Db format in quotation
SQL

Share