Question

Suppose the last row has the AUTO_INCREMENT column value 32. Suppose a new row is added by setting AUTO_INCREMENT value equal to 100. The next row added will have value _____________

(a) 32

(b) 33

(c) 100

(d) 101

I have been asked this question in a job interview.

Origin of the question is Working with Sequences topic in division Data Types of MySQL

Answer 1

Correct option is (d) 101

To elaborate: If the new value is larger than the current next sequence number, then the sequence is reset to continue with the next value after that for the following rows. In this way, “bumping up” the counter is done.