/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 vote231 views2 answers
Find lowest number in sql
SQL
0 vote260 views1 answer
Mysql get hour from datetime
SQL
2 votes246 views2 answers
Install postgresql
SQL
8 votes237 views2 answers
Python simple connect to mysql
SQL
0 vote237 views1 answer
Mysql make date from 2 column
SQL
0 vote228 views1 answer
Postgresql add not null and not empty constraint
SQL
21 votes234 views4 answers
Add column mssql
SQL
11 votes250 views5 answers
Update table from another table mysql
SQL
5 votes235 views1 answer
Postgresql functions
SQL
0 vote251 views2 answers
Connect to mysql server mac terminal
SQL

Share