如下,同一张表,有4条分开的新增字段的sql,
alter table a
add column column1 tinyint null default null
comment 'column1:0否,1是'
after xx;
alter table a
add column column2 tinyint null default null
comment 'column2:1员工,2运营'
after xx;
alter table a
add column column3 tinyint null default null
comment 'column3:1可以开票,2不可以开票'
after xx;
alter table a
add column column4 tinyint null default null
comment 'column4:1否,2通知至工作台,3通知至订单详情'
after xx;
需求:把这四条sql合并为一条sql:
alter table a
add column column1 tinyint null default null
comment 'column1:0否,1是'
after xx,
add column column2 tinyint null default null
comment 'column2:1员工,2运营'
after xx,
add column column3 tinyint null default null
comment 'column3:1可以开票,2不可以开票'
after xx,
add column column4 tinyint null default null
comment 'column4:1否,2通知至工作台,3通知至订单详情'
after xx;