Okay, so I'm kinda curious as to what to do here. I'm using auto_increment to just provide a unique int for every row in the table. But over a couple years, lets say, the full range of an int will get used up (4294967295).
What can you do to avoid this problem? Or is there a way to fix it once it does fill up?
This comes to mind as I've recently seen this problem with a friends development using Access and ASP. Where their auto_increment type got filled up over a couple years - then started acting kooky.
They ended up having to copy all the data into a new table to start the counter all over again.
Is there a way to have mySQL or PHP fill use freed-up values in an auto_increment field?
What can you do to avoid this problem? Or is there a way to fix it once it does fill up?
This comes to mind as I've recently seen this problem with a friends development using Access and ASP. Where their auto_increment type got filled up over a couple years - then started acting kooky.
They ended up having to copy all the data into a new table to start the counter all over again.
Is there a way to have mySQL or PHP fill use freed-up values in an auto_increment field?