Re: DELETE syntax and auto_increment 'reset'

At 18:29 -0400 5/22/02, Jule wrote: >Hey guys, >when i delete a row using the query DELETE FROM $table WHERE id = "3" LIMIT 1; > >how can i make it that the id column (auto_increment) starts over from 1 and >build up to however many rows there are without counting 1 2 4 5 6 etc.? If you're asking

DELETE syntax and auto_increment 'reset'

Hey guys, when i delete a row using the query DELETE FROM $table WHERE id = "3" LIMIT 1; how can i make it that the id column (auto_increment) starts over from 1 and build up to however many rows there are without counting 1 2 4 5 6 etc.? any ideas? Jule -- |\/\__/\/| |