Resetting auto_incremented values
| From: | Martin Clifford | Date: | Thu, 20 Jun 2002 15:08:07 +0000 |
| Subject: | Resetting auto_incremented values | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19907@lists.php.net to get a copy of this message | ||
Hi all,
I have a table that has ARTICLE_ID as the primary key, auto_incremented. I have added three rows to
this table, yet I want to delete the third. Here it is now:
1 - Item 1
2 - Item 2
3 - Item 3
My question is, how do I delete Item 3, without having the next row's index becoming 4?
1 - Item 1
2 - Item 2
4 - Item 3
Thanks in advance!
Martin