New related comments
Number of comments in the last 48 hours
Location of mysql startup script
Best operating system settings for mysql throughput
Monitoring mysql status
How to change the next value of an auto_increment field
This article has not been rated yet. After reading, feel free to leave comments and rate it.
Question:I have a table where the primary key is an auto increment field. I just deleted the last 2 rows and when the next record will be created it will use the next higher number but I'd like to subtract 2 from the auto_increment value. How can I do this?
Answer:Use the ALTER TABLE statement as shown below: