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
How do I install and use mysql?
What is difference between mysql and mysql workbench?
what is database white box testing? : Mysql dba
How to create table show example
What is regex in mysql?
How do I stop a mysql service?
What is memory table?
Why we use mongodb instead of mysql?
What are stored procedures and functions?
How to enter Characters as HEX Numbers?
How do I select a database in mysql?
How do I rename a procedure?
What is horizontally scalable?
How can we find out which auto increment was assigned on Last insert?
What is a user defined variable?