[PHP-DB] Re: Resetting auto_incremented values From: Andy (news.letters <email protected>)
Date: 06/20/02

sorry buddy, as far as I know you can't.
The only thing you can do is to set the counter higher but you can't return
to a value under
the given row.

Please correct me if I am wrong,

Andy 

--
----------------------------------------------------
http://www.globosapiens.net
Global Travellers Network!

"Martin Clifford" <MLC1 <email protected>> schrieb im Newsbeitrag
news:sd11bb35.021 <email protected>
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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php