I have a MySQL table naming Product for a classified site, product_id is bigint(20) AUTO_INCREMENT field.
Currently AUTO_INCREMENT value is 224143.
Client want it to restart from 1. but this table has 7000 existing STARTING from prduct_id 210235 to 224143. User can manage their items by using its id, i can not revise, regenerate ids, but want to restart next AUTOINCREMENT ENTRY from 1, and hold the existing record as it is.
Thanks in advance.