Question

In a MyISAM table, if the maximum value of an AUTO_INCREMENT increment column is 12 and that row is deleted, the next value generated is _____________

(a) 12

(b) 13

(c) 1

(d) 14

This question was posed to me in semester exam.

My question is taken from Working with Sequences in chapter Data Types of MySQL

Answer 1

Right answer is (b) 13

The explanation: In the MyISAM tables, AUTO_INCREMENT sequences normally are monotonic. The values in an automatically generated series are strictly increasing. They are not reused when rows are deleted.