ALTER TABLE table_name ADD COLUMN column_name1 column_type [COMMENT col_comment] [FIRST|AFTER column_name2]
table_name: Name of the target tablecolumn_name1: Column to be addedcolumn_type: Type of the column to be addedcol_comment: Comment for the column to be addedcolumn_name2: Column followed by the added columnALTER TABLE `TBL` ADD COLUMN `COL2` STRING COMMENT 'test' AFTER `COL1`ALTER TABLE `TBL` ADD COLUMN `COL2` STRING COMMENT 'test' FIRST
フィードバック