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 regexp?
How do you create a schema?
What is meant by sharding?
How do I kill a mysql query?
What tools available for managing mysql server?
How do I edit a table in mysql?
How to run a sql statement?
Explain the difference between delete and truncate.
What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?
How can you change the password of a mysql user?
What language is mysql written in?
Why mysql is used with php?
What are the advantages of a procedure?
What is difference between inner vs self vs cross?