/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 vote116 views3 answers
Connection string mysql
SQL
0 vote111 views1 answer
Dynamic where clause in sql server stored procedure
SQL
17 votes97 views6 answers
Mysql import sql file
SQL
0 vote105 views1 answer
Openquery update linked server
SQL
0 vote104 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
1 vote104 views1 answer
Increasing font and zooming in mysql workbench
SQL
0 vote104 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote102 views1 answer
Default value false mysql
SQL
0 vote62 views2 answers
Spring properties file for db
SQL
1 vote102 views1 answer
Sql drop with dependencies
SQL

Share