一次添加多个列语法不支持after

Viewed 25

image.png

给一个表添加多个列,想指定after某一列,语法报错。

建议在添加多列场景下,支持:整体after或者单列after语句,事例如下:

alter table db.table ADD COLUMN (ad_id bigint key null comment '广告ID' after media_id, sponsor_id bigint key null comment '广告主ID' after media_id, sponsor_group_id bigint key null comment '广告主分组ID' after media_id ) ;

alter table db.table ADD COLUMN (ad_id bigint key null comment '广告ID' , sponsor_id bigint key null comment '广告主ID' , sponsor_group_id bigint key null comment '广告主分组ID' ) after media_id;

1 Answers

目前支持这种语法,可以改写下

ALTER TABLE my_table
ADD COLUMN col1 INT DEFAULT "0" AFTER v_1,
ADD COLUMN col2 VARCHAR(100) DEFAULT NULL AFTER col1,
ADD COLUMN col3 DECIMAL(10,2) DEFAULT "0.00" AFTER col2;