Resetting auto_increment fields

Resetting the auto_increment id field in the tables can be a hassle. Here is how to reset id to run from 0; this is done from the MySQL client.

mysql> set @var_name = 1000;

# offset ids by 1000 first

mysql> update tablename set id = (@var_name := @var_name + 1);

# reset to 0

mysql> set @var_name = 0;

# set ids to run from 0:

mysql> update tablename set id = (@var_name := @var_name + 1);