What happens when the column is set to AUTO INCREMENT and
you reach the maximum value for that table?

Answers were Sorted based on User's Feedback



What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that tab..

Answer / sanjeev b

If the AUTO_INCREMENT reaches the maximum value then we
cant insert the rows into that table. If we try to insert
the values it will produce an error saying 'Duplicate
entry 'max value(ex:4294967295)' for key1

Is This Answer Correct ?    9 Yes 0 No

What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that tab..

Answer / 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

More MySQL Interview Questions

How to drop an existing table in mysql?

0 Answers  


What is truncate in mysql?

0 Answers  


If you wish to encrypt the username and password using php, how will you do that?

0 Answers  


What are date and time data types?

0 Answers  


What is the difference Delete and Drop ?

6 Answers  






Why is it called mysql?

0 Answers  


What is tee command in mysql?

0 Answers  


How can I connect mysql database?

0 Answers  


What is datatype in mysql?

0 Answers  


How can you make a database as your current database?

0 Answers  


What is full form of xampp?

0 Answers  


What are CSV tables?

1 Answers  


Categories