Question

In MyISAM tables, when a table is emptied with the TRUNCATE TABLE, the counter begins at _____________

(a) 0

(b) 1

(c) -1

(d) arbitrary

I got this question in examination.

I'd like to ask this question from Working with Sequences topic in section Data Types of MySQL

Answer 1

Correct option is (b) 1

Explanation: In the MyISAM tables, whenever a table is truncated with the ‘TRUNCATE TABLE’ clause, the ‘AUTO_INCREMENT’ counter again gets reset. It begins with the value one and increases monotonically.