What happens when the column is set to AUTO INCREMENT and
you reach the maximum value for that table?
- 2 Answers
- 11839 Views
- I also Faced
- E-Mail Answers
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
What is mysql installer?
How do I clear the screen in mysql?
What is a delimiter in mysql?
What is database engine in mysql?
What is key in mysql?
What is meant by decimal (5,2)?
Is mysql distributed?
Explain Access Control Lists.
How Switch (select or use) to a database.
How to create a new table by selecting rows from another table in mysql?
how to display nth highest salary from a table in a mysql query? : Mysql dba
What are the different types of triggers in mysql?
How do I fix a crashed mysql database?
How to include character strings in sql statements?
What language does mysql use?
