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
- 12279 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 the difference between now() and current_date()?
Why do we use the mysql database server?
Do I need to pay for mysql?
How do I install mysql workbench?
What is int unsigned?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
write a command to view the content of the table
What is mysql shell?
Why we use mongodb instead of mysql?
How do I get a list of table names in mysql?
Which is faster mongodb or mysql?
Explain advantages of MyISAM over InnoDB?
-
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)
