What happens when the column is set to AUTO INCREMENT and
you reach the maximum value for that table?
Answer Posted / amith
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.
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
How do I start mysql?
How do you create a primary key?
How to connect html form to mysql database using php?
How do I check mysql version?
What are enums used for in mysql?
What are queries used for?
What are date and time intervals?
How do I show users in mysql?
How to store binary data in mysql?
What is limit in mysql?
Write a query to select all teams that won either 1, 3, 5 or 7 games.
Write a query to fetch common records between two tables using mysql?
Explain about the architecture of MYSQL?
What is mysql procedure?
What is mysql and how it works?