Re: Resetting auto_incremented values

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