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

Write a command to view mysql database table structure?

0 Answers  


Why do we use group by and order by function in mysql?

0 Answers  


What is difference between mysql and mysql server?

0 Answers  


What is the insert?

0 Answers  


What is mysql root?

0 Answers  


What is difference between statement and preparedstatement?

0 Answers  


What is the diff. bwt. primary key and unique key?

4 Answers  


What is the difference between SQL and SQL Server?

3 Answers   Cognizant, HCL,


What are the other commands to know the structure of a table using mysql commands except explain command?

0 Answers  


Why are function needed?

0 Answers  


How do you know the version of your mysql server?

0 Answers  


How do I show columns in mysql?

0 Answers  


Categories