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
What are the steps involved in query processing?
Write a query to count the number of rows of a table in mysql.
Do I need to pay for mysql?
What is difference between mongodb and mysql?
How do I find mysql database?
How can you make a database as your current database?
What is difference between oracle and mysql?
In mysql, what is joins? Explain
How do I edit a trigger in mysql?
What is the maximum no of columns a table can have?
Can we write procedure in mysql?
Is mysql from oracle?
Can you tell the difference between mysql_fetch_object and mysql_fetch_array?
What are the different tables present in MySQL?
How to returns the columns and column information pertaining to the designated table.