Date: 01/18/06 (MySQL Communtiy)    Keywords: no keywords

I have a field in a table that is an auto-increment id field. Normally the numbers are okay, but sometimes I need to change the id for a record. Apart from making sure that the number isn't already taken by another record, is there anything else I need to worry about when changing the id field?

I've done some research on this, but I haven't been able to find exactly what I'm looking for. (Probably don't know the right words to look for.)

Source: http://community.livejournal.com/mysql/83058.html