DBA > Job Interview Questions > MySQL and SQL

What happens when the column is set to AUTO INCR

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?

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.

(Continued on next question...)

Other Job Interview Questions