What happens when the column is set to AUTO INCREMENT and
you reach the maximum value for that table?
- 2 Answers
- 11379 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 |
Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.
What is int unsigned?
What is the difference between CHAR and VARCHAR data types?
What is dump in mysql?
What are the other commands to know the structure of a table using mysql commands except explain command?
What are the difference between now and current_date in mysql?
How Switch (select or use) to a database.
what is constraints?
How to update database permissions/privilages.
Is there an object-oriented version of MySQL library functions?
What does it mean to be case sensitive?
What is a transaction? Describe mysql transaction properties.
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
