in reply to Re: MySQL / Perl
in thread MySQL / Perl

This is the way: but if it's important to have the min. value it's probably worth leaving the row instead of deleting it. IME, when one deletes the entire contents of the table, the auto_increment starts again from 1.

§ George Sherston