Interview Preparation mode beta
Funny Facebook Status Funny Facebook Status
Enter your email address

What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?

Nice?Vote!

1 Answer

Nice?Vote!
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.
answered 1 year ago by R (19,530 points)

Related questions