/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 vote285 views2 answers
Add colum in sql
SQL
0 vote259 views1 answer
How to print records of employees hired in particular month in oracle
SQL
17 votes246 views2 answers
How to assign date field for table in mysql
SQL
0 vote288 views1 answer
Mysql backup query
SQL
4 votes262 views4 answers
What is primary key
SQL
0 vote251 views1 answer
Double in sql server example
SQL
0 vote265 views1 answer
Big table in mysql
SQL
3 votes283 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote280 views1 answer
Will graphql replace sql
SQL
0 vote282 views1 answer
Error code 1241 mysql
SQL

Share