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 does mysql flush hosts do?
What mysql means?
What is data type for image in mysql?
What is table level locking in mysql?
Is mysql good for big data?
How do I install mysql?
How large can a mysql database become?
How do I tune a mysql query?
What is truncate in mysql?
Is mysql distributed?
Are stored procedures precompiled?
What is pdo :: fetch_assoc?
What are triggers in mysql?
How do you create a new database in mysql?
What is pdo connection?