in reply to Mysql autoincrement problem

Why would you care what the Customer_ID is? How will it make your application work any better, if after adding a customer with ID 1005, MySQL goes back to 4 for the next ID?