Anyway to reset MySql's AUTO_INCREMENT counter?
| From: | elias | Date: | Thu, 26 Jul 2001 09:43:36 +0000 |
| Subject: | Anyway to reset MySql's AUTO_INCREMENT counter? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-59705@lists.php.net to get a copy of this message | ||
Hi.
Usually, Any AUTO_INCREMENT field in MySql table will have always an
incrementing value.
Now Suppose I emptied the table and then inserted one record, why not this
record LAST_INSERT_ID is not '1' or '0' and why it is the lastid+1 before I
empty the table?
Can't I reset that pointer w/ deleting the table and creating it again?