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
Is mysql same as mariadb?
Can mysql handle big data?
What is a heap table?
Can you rename a database in mysql?
What is the return type of mysqli_query?
How to get the current date in mysql?
How do I optimize a selected query in mysql?
Can we use mysql and mysqli together?
what is the procedure to configure the application of mysql?
What is the password of mysql?
How large can a mysql table be?
Explain the different types of mysql joins.
What is ddl, dml, and dcl?
How to include character strings in sql statements?
What is 'mysqlimport'?