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 does blob mean in mysql?

0 Answers  


What are the limitations of mysql?

0 Answers  


What do you need to connect php to mysql?

0 Answers  


What are the non-standard sql commands supported by 'mysql'?

0 Answers  


How many mysql connections can handle?

0 Answers  


What is foreign key in mysql?

0 Answers  


What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

0 Answers  


What causes mysql too many connections?

0 Answers  


how can you test for null values in a database? : Mysql dba

0 Answers  


What is the difference between char and varchar data types?

6 Answers  


What is the difference between b-tree and hash indexes?

0 Answers  


What are the advantages of mysql in comparison to oracle?

0 Answers  


Categories