I have the auto_increment on one of my variables. During the past few days
I have been doing testing on a "live" database and created several test
records which I now have deleted from my table. Is there any way of setting
the auto_increment value to match the last "correct" number? Ron
You don't say what database application you're using, but if it's MySQL, you can change the auto increment value using:
ALTER TABLE tablename AUTO_INCREMENT = 1
That being said, you actually don't have to do this (and often shouldn't, really). Having gaps in your auto increment sequence shouldn't be a problem.
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php