Use this query to alter the auto-increment value of any table .eg:alter table tbl_name auto_increment=10;