Detailed explanation and options for the selected question.
ALTER TABLE with ADD COLUMN is used to add a new column to an existing table. MODIFY TABLE and UPDATE TABLE are invalid commands.