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: