What happens when the column is set to AUTO INCREMENT and
you reach the maximum value for that table?
Answer Posted / 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 |
Post New Answer View All Answers
Why do we use pragma autonomous transaction?
How do I disable mysql?
What is cast in mysql?
What is the hostname for mysql database?
What is mysql slow query?
How do I install mysql workbench?
What is an index? How can an index be declared in mysql?
What does "i_am_a_dummy flag" do in mysql?
What is a transaction? Describe mysql transaction properties.
What does mysql flush hosts do?
Is mysql same as mariadb?
Is mysql good for big data?
Can I use mariadb instead of mysql?
What are date and time data types?
Is mysqli deprecated?