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.

Jay Paulson
Developer, Web Technologies
Viatel, Inc.

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]

Reply via email to