/SQL/Mysql reset auto increment id

Mysql reset auto increment id

Mysql reset auto increment value

ALTER TABLE table_name AUTO_INCREMENT = 1;

18

Mysql reset auto increment

ALTER TABLE `Table Name` AUTO_INCREMENT = 1;

2

Mysql reset auto increment to 1

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 vote192 views1 answer
Drush run sql select
SQL
0 vote167 views2 answers
How to save result of sqlite query in a table
SQL
0 vote186 views1 answer
Can you write relational algebra into sql queries
SQL
1 vote170 views1 answer
Too many connections mysql
SQL
1 vote183 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote162 views1 answer
Sql inserted
SQL
3 votes127 views1 answer
V$session not found in oracle
SQL
1 vote169 views1 answer
Search for replace in mysql
SQL
1 vote205 views1 answer
Homebrew install mysql
SQL
8 votes204 views1 answer
Database backup in mysql server recovery
SQL

Share