Yeah, it's asked a lot!! And I've always answered that question....( it's not the only question I answer!!! )
But Good Luck!! And your welcome!!! Dan On Monday, July 29, 2002, at 10:51 PM, [EMAIL PROTECTED] wrote: > why, is this question asked a lot??? anywa, thanks, i was gonna try > something like that from something i read in the mysql manual, but it > only > mentioned it passing and didnt give an example or anything. > > tanx > > "Daniel Brunner" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... >> Once again... >> >> >> ALTER TABLE table1 AUTO_INCREMENT = 500 >> >> >> Dan >> >> >> >> On Monday, July 29, 2002, at 10:44 PM, [EMAIL PROTECTED] wrote: >> >>> rite, >>> >>> my primary key column ("id") is set to auto_increment as usual which >>> is >>> very >>> handy. But when I delete a row, the auto_increment just keeps >>> incrementing >>> and there's this 'hole' left where I deleted the row! >>> >>> Apart from this looking ugly, it poses another problem. In my PHP >>> script >>> where I can add new rows, I query the table, checking how many rows in >>> the >>> table altogether and set the new id as the next number, but this >>> doesnt >>> work >>> if theres 'holes' in the id field, as the new record tries to >>> overwrite >>> another id. >>> >>> So I've 2 questions >>> 1) Can the next auto_increment value be 'set' by a SQL query???? >>> 2) Can I get a SQL query to INSERT INTO the first 'hole' it finds in >>> the ID >>> column?? >>> >>> TIA >>> >>> >>> >>> -- >>> 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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php