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
What is a string in mysql?
What are the non-standard sql commands supported by 'mysql'?
Write a query to fetch duplicate records from a table using mysql?
How important is to list the column names when doing an insert?
What is definer in mysql trigger?
What is the difference between MyISAM Static and MyISAM Dynamic?
Describe mysql transaction properties.
What are the security alerts while using mysql?
How do I create a stored procedure in mysql?
List data types in mysql? Explain
What are the differences between binary and varbinary?
What is a data directory?
What are procedures in mysql? Explain
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
What are the technical features of MySQL?