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
- 12262 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 mysql server used for?
How many ways we can we find the current date using MySQL?
How to copy data from one server to another using php?
how can you test for null values in a database? : Mysql dba
How to store values to array from mysql database in php?
How to delete a column and add a new column to database
How do I know if mysql is running on windows?
How do you connect MySQL database with PHP?
How many threads can mysql handle?
Do I need python for mysql?
What is the data source name for mysql?
Which is better sqlite or mysql?
-
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)
