easy db question
| From: | Paulson, Joseph V. \"Jay\" | Date: | Mon, 02 Apr 2001 21:45:39 +0000 |
| Subject: | easy db question | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-8153@lists.php.net to get a copy of this message | ||
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