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 append query?
How to validate email addresses in mysql?
Can not connect to mysql server 10060?
How to get the current date in mysql?
How can you change the name of any existing table by using the sql statement?
What does mysql workbench do?
How do we delete a row in a table?
Is mysql and sql are same?
How do I edit a database in mysql workbench?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
How to upload a large file through phpmyadmin in mysql?
How to use 'mysql' to run sql statements?
What is a storage engine? What are the differences between innodb and myisam engines?
How database are managed?
What does mysql_query return?