Question

Which among the following is the correct syntax for modifying the definition of an existing table?

(a) ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT;

(b) ALTER TABLE person  person_id SMALLINT UNSIGNED AUTO_INCREMENT;

(c) ALTER TABLE person MODIFY person_id ;

(d) ALTER TABLE person

I got this question in an online quiz.

I'm obligated to ask this question of Populating & Modifying Tables topic in chapter Using SQL to Manage Data of MySQL

Answer 1

The correct option is (a) ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT;

Explanation: None.