Despite it being simple, I always forget the syntax to reset AUTO_INCREMENT in MySQL. I’m posting this for my reference and hopefully others will find it useful.
ALTER TABLE table_name AUTO_INCREMENT = next_increment_number
Despite it being simple, I always forget the syntax to reset AUTO_INCREMENT in MySQL. I’m posting this for my reference and hopefully others will find it useful.
ALTER TABLE table_name AUTO_INCREMENT = next_increment_number