/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 vote160 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote191 views1 answer
Sql query use select name inside where clause
SQL
0 vote228 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote169 views1 answer
Update table sql multiple set
SQL
0 vote161 views1 answer
Sql insert tuple
SQL
0 vote167 views1 answer
Procedure excute monthly oracle
SQL
1 vote176 views2 answers
Sql server concat string and int
SQL
2 votes169 views1 answer
Mysql set value as null
SQL
1 vote178 views2 answers
Get table column names sql laravel
SQL
0 vote184 views1 answer
Neo4j command to run script file
SQL

Share