Login
Register
All Activity
Questions
Unanswered
Tags
Users
Ask a Question
About Us
986
Questions
785
Answers
Interview Preparation mode
beta
Funny Facebook Status
Enter your email address
All categories
SQL Server Interview Questions and Answers
(197)
SSIS Interview Questions and Answers
(54)
SSRS Interview Questions and Answers
(9)
SSAS Interview Questions and Answers
(29)
.NET Interview Questions and Answers
(186)
Oracle Interview Questions and Answers
(122)
Java Interview Questions and Answers
(32)
UNIX Interview Questions and Answers
(47)
Networking Interview Questions and Answers
(17)
MySQL Interview Questions and Answers
(30)
HR Interview Questions and Answers
(237)
General Interview Questions and Answers
(9)
Other Interview Questions and Answers
(8)
Job Openings
(3)
Greenplum Database Interview Questions and Answers
(5)
What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
Nice?
Vote!
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql
mysql-interview-question
increment
1 Answer
Nice?
Vote!
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.
answered
1 year
ago
by
R
(
19,530
points)
Related questions
Nice?
Vote!
1
answer
What happens if a table has one column defined as TIMESTAMP?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql
mysql-interview-question
timestamp
Nice?
Vote!
2
answers
If you specify the data type as DECIMAL (5,2), what’s the range of values that can go in this table?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql
mysql-interview-question
datatype
Nice?
Vote!
1
answer
If I created a column with data type VARCHAR(3), what would I expect to see in MySQL table?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql
mysql-interview-question
datatype
Nice?
Vote!
1
answer
What if you really want to store the timestamp data, such as the publication date of the article?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql-interview-question
mysql
timestamp
Nice?
Vote!
1
answer
How do you control the max size of a HEAP table?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql-interview-question
mysql
heap