Re: Resetting auto_incremented values

Hello!! ALTER TABLE $table1 AUTO_INCREMENT = 3 Dan On Thursday, June 20, 2002, at 01:44 PM, news.letters@gmx.de wrote:

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@nrc.gov> schrieb im Newsbeitrag news:sd11bb35.021@nrcgwia.nrc.gov... 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