Forum : What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
Brief description about Online courses   join in Online courses
Home News Viewpoint
Travel Entertainment Auto Gadgets & Electronics Sports Lifestyle Food
Rankings Whitepapers Blogs Conferences About Us
View Balu Prasad 's Profile

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??????
Asked by Balu Prasad | Mar 18, 2010 |  Reply now
Replies (1)
View teacher siliconindia 's Profile
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.
Mar 18, 2010

Forum By Category