Home » Unlabelled » What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table? | MySQL Interview Questions
Wednesday, 17 October 2012
What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table? | MySQL Interview Questions
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.
No comments:
Post a Comment