Question

The AUTO_INCREMENT column attribute is best used with ______________

(a) FLOAT

(b) INT

(c) CHARACTER

(d) DOUBLE

I have been asked this question in quiz.

My doubt is from Using Perl DBI in Web Applications in chapter MySQL Programs Using Perl DBI and PHP of MySQL

Answer 1

The correct option is (b) INT

The explanation is: The AUTO_INCREMENT is a column attribute and it is best used with the integer datatypes. It automatically assigns monotonically increasing values to the AUTO_INCREMENT columns.