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
- 12408 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 does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?
How to enable or disable a row of a table using MySQL in struts?
What is procedures in mysql?
How we can create index in mysql?
What is 'mysqld'?
What is the function of myisamchk?
Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools?
What is slow query log in mysql?
how many ways we can get the current date in mysql?
Explain the difference between FLOAT, DOUBLE and REAL.
How can we get the number of rows affected by query?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
-
Oracle (3259) - 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)
