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.

Larry

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to