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,


Global Travellers Network!

"Martin Clifford" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
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!


PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to