/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

1 vote335 views1 answer
Trim leading zeros in sql
SQL
31 votes326 views3 answers
SQL Server change column data type
SQL
0 vote318 views1 answer
Mysql insert into select with recursive
SQL
1 vote311 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
0 vote313 views1 answer
TSQL function split string
SQL
1 vote340 views1 answer
Sql dcl
SQL
2 votes326 views1 answer
Mysql virtual column
SQL
0 vote369 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
1 vote331 views1 answer
Sql server cast date dd/mm/yyyy
SQL
10 votes345 views2 answers
Oracle alter sequence nextval
SQL

Share