What happens when the column is set to AUTO INCREMENT and
you reach the maximum value for that table?
- 2 Answers
- 11369 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
How do I edit a table in mysql workbench?
How can we convert between Unix & MySQL timestamps?
How we can get the current date in mysql?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
What are the functions of commit and rollback statements?
What is regex in mysql?
Can you tell how many values can set the function of mysql to consider?
What is the command line end user interface - mysql?
How to print message in mysql trigger?
How are mysql timestamps seen to a user?
Why use mysql procedures?
How can you take the backup and restore a mysql database using php?
How do I view mysql logs?
How can I connect mysql database?
What is truncate in mysql?
