Tuesday, December 8, 2009

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

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

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

If you are really interested about our blogger, Please Share your opinion here ...

If you Found Any Interviews in your reliable sources, Please Post the information through this Comment and It will be Published in our blogger. help every one to get a Job.