hello everyone-
I'm running MySQL 3.23.27-beta with php 4.04pl1. What I am wondering is I
have an auto incrementing field and if I delete all the entries in the table
with this field the incrementing doesn't start over. For example, if I
insert 6 records for the first time into this table the auto incremenator
gets set to 6 for the last position. Now, if I go and delete all 6 of these
entries and then insert 6 more after the deletion the auto incrementing
starts off at 7 and goes through 12. I'm just curious if there is a way
around this so that if all the records are deleted the auto incrementing
field will start back at 1.
Thanks,
Jay Paulson
Developer, Web Technologies
Viatel, Inc.
http://www.viatel.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]