/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

17 votes148 views4 answers
Set mysql Password
SQL
1 vote137 views1 answer
Show table columns
SQL
3 votes152 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
1 vote176 views2 answers
Login to mysql
SQL
2 votes137 views1 answer
Sql create database
SQL
1 vote149 views1 answer
Select users with same username
SQL
0 vote172 views1 answer
Openquery update linked server
SQL
3 votes160 views2 answers
Search text in all sql server stored procedure
SQL
10 votes99 views1 answer
Oracle view dependencies
SQL
0 vote144 views1 answer
My sql data file extention
SQL

Share