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 import database through command line?
How do I automate a backup in mysql?
How to get a list of columns in an existing table?
What are date and time intervals?
How do I edit a database in mysql workbench?
How can I see mysql database?
What is the difference between BLOB AND TEXT?
How do I create a stored procedure in mysql?
List the different types of normalization?
How much does mysql cost?
What is striped backup
Is mysqli faster than mysql?
What is a crosstab query?
How we can create index in mysql?
How will you export tables as an xml file in mysql?