Dealing with auto-increment in MySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?

Just curious.

Thanks!

- sf

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux