Interested to Buy Any Domain ? << Click Here >> for more details...
What happens when the column is set to AUTO INCREMENT and
you reach the maximum value for that table?
- 2 Answers
- 12495 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 |
how many ways we can get the current date in mysql?
How many columns can you create for an index?
What is mysql database used for?
Which is best pdo or mysqli?
What is default password for mysql?
Do I need to pay for mysql?
What are the differences between drop a table and truncate a table?
Why does mysql have so many connections?
How many rows mysql can handle?
How does mysql encrypt passwords?
What is the difference between unix timestamp and mysql timestamp?
What is the difference between is null & is not null?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
