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 bdb (berkeleydb)?
How database are managed?
What does it mean to be case sensitive?
Is mysql free software?
Explain % and _ inside like statement?
How do you create a new database in mysql?
How do I select a database in mysql?
Is there a free mysql?
List some mysql advantages and disadvantages?
How can you validate emails using a single query?
Is mysqli faster than mysql?
How do I delete a mysql user?
What is msql?
What are the 'mysql' command line arguments?
How many columns can a table have?