Hello!! ALTER TABLE $table1 AUTO_INCREMENT = 3
Dan On Thursday, June 20, 2002, at 01:44 PM, [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> schrieb im Newsbeitrag > news:[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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
