# To Set the value of auto increment in an already existing table use: ALTER TABLE tables_name AUTO_INCREMENT=500; # Or whatever number you desire