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

What are the differences between mysql vs sql server?

0 Answers  


How many columns can be used for creating Index?

0 Answers  


What is dbms in mysql?

0 Answers  


Why mysql is used with php?

0 Answers  


What is the use of ENUM in MySQL?

1 Answers  






What is mysql and mysqli?

0 Answers  


What is a blob datatype?

0 Answers  


In which year mysql created?

0 Answers  


What is latest version of mysql?

0 Answers  


what is the difference between gui testing and database testing? : Mysql dba

0 Answers  


How to change the database engine in mysql?

0 Answers  


Explain federated tables?

3 Answers   Tech Mahindra,


Categories