What happens when the column is set to AUTO INCREMENT and
you reach the maximum value for that table?
- 2 Answers
- 11760 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / amith
It stops incrementing. It does not overflow to 0 to prevent
data losses, but further inserts are going to produce an
error, since the key has been used already.
| Is This Answer Correct ? | 11 Yes | 3 No |
What is delimiter in mysql?
Why should I learn mysql?
What is prepare statement in mysql?
What is mysqli_num?
How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
Explain advantages of InnoDB over MyISAM?
What does mysql_fetch_assoc do?
What is mysql used for?
What is the difference between mysql and pdo?
How to calculate the difference between two dates?
How do I change the max connection in mysql?
-
Oracle (3257) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
