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 can I connect mysql database?
How do I run mysql without installing?
What is mysql common?
How do I start mysql manually?
What do ddl, dml, and dcl stand for?
Why mysql is used with php?
What is general log in mysql?
What are the applications required to support mysql?
What is mysql workbench used for?
How important is to list the column names when doing an insert?
What are the differences between mysql vs sql server?
What are the advantages of mysql in comparison to oracle?
How will show all records containing the name "sonia" and the phone number '9876543210'
What is difference between function and procedure in mysql?
Is blocked because of many connection errors mysql?