New answers tagged


If you ever need ALTER TABLE tablename AUTO_INCREMENT = 1 you are probably misusing AUTO_INCREMENT. AUTO_INCREMENT is designed to provide unique keys, nothing more. If you need it to be "1", you should invent your own mechanism; do not trust AUTO_INCREMENT. Would you care to explain your purpose? Perhaps we can help you find a suitable workaround. (No "...

Top 50 recent answers are included