What happens when the column is set to AUTO INCREMENT and
you reach the maximum value for that table?
Answers were Sorted based on User's Feedback
Answer / sanjeev b
If the AUTO_INCREMENT reaches the maximum value then we
cant insert the rows into that table. If we try to insert
the values it will produce an error saying 'Duplicate
entry 'max value(ex:4294967295)' for key1
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / 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 |
What are the differences between mysql vs sql server?
How many columns can be used for creating Index?
What is dbms in mysql?
Why mysql is used with php?
What is the use of ENUM in MySQL?
What is mysql and mysqli?
What is a blob datatype?
In which year mysql created?
What is latest version of mysql?
what is the difference between gui testing and database testing? : Mysql dba
How to change the database engine in mysql?
Explain federated tables?