/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

5 votes172 views3 answers
Mysql check if null or empty string
SQL
2 votes201 views1 answer
Postgresql group by month and year
SQL
2 votes180 views2 answers
Storing timezones in postgres
SQL
4 votes174 views1 answer
Mysql biginteger size
SQL
2 votes163 views1 answer
Mysql auto increment jumping
SQL
0 vote183 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
1 vote181 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote167 views1 answer
Sql insert from excel
SQL
9 votes153 views2 answers
Cmd to rename a collumn name in sql
SQL
1 vote175 views1 answer
Cross schema query oracle 2 users
SQL

Share