What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
By Balu Prasad
What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table??????
Teacher SiliconIndia replied to Balu Prasad Thursday, March 18, 2010
Hi Balu,
It stops incrementing. It does not overflow to 0 to prevent data losses, but further inserts are going to produce an error, since the key has been used already.
