Steve Finkelstein wrote:
How're you folks dealing with records that are auto incremented in MySQL
after a delete is made? I've noticed the only way to get a sequential order
back is to truncate the table completely.
Do you use logic in your code to find a missing ID and insert new records
based on that? Or do you just ignore it, let mysql handle the numbering and
go on with your lives?
Don't touch the deleted id's. You don't need them.
If you re-order your id's, you're creating havoc (think of table "b"
referencing the first table - all the id's are screwed up there too).
What problem are you trying to solve?
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
