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 do you connect MySQL database with PHP?

709


What is indexing in mysql?

635


What does innodb stand for?

691


Is mysql running ubuntu?

652


How do I download mysql on my laptop?

654


How does mysql store dates?

673


What are the advantages of a procedure?

672


What is a scalar function?

706


How to extract a unit value from a date and time?

678


How do I find my mysql username and password?

729


When to use order by in delete statement?

760


Write command to import an mysql file?

682


How to execute mysql query in php?

653


How do I delete a mysql user?

622


What are aggregate functions in mysql?

946