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


Please Help Members By Posting Answers For Below Questions

How can I connect mysql database?

472


How do I run mysql without installing?

473


What is mysql common?

479


How do I start mysql manually?

467


What do ddl, dml, and dcl stand for?

477






Why mysql is used with php?

488


What is general log in mysql?

456


What are the applications required to support mysql?

480


What is mysql workbench used for?

505


How important is to list the column names when doing an insert?

585


What are the differences between mysql vs sql server?

472


What are the advantages of mysql in comparison to oracle?

545


How will show all records containing the name "sonia" and the phone number '9876543210'

520


What is difference between function and procedure in mysql?

446


Is blocked because of many connection errors mysql?

433