ALTER TABLE `t_order`
ADD COLUMN `reimburse_num` varchar(50) NULL COMMENT '报销单号' AFTER `corp_name`,
ADD COLUMN `finance_org` varchar(36) NULL COMMENT '财务组织' AFTER `reimburse_num`,
ADD COLUMN `pk_cost_center` varchar(20) NULL COMMENT '成本中心主键' AFTER `finance_org`,
ADD COLUMN `cost_center_name` varchar(50) NULL COMMENT '成本中心名称' AFTER `pk_cost_center`,
ADD COLUMN `reimburse_line_num` bigint(20) NULL COMMENT '报销单行号' AFTER `cost_center_name`,
ADD COLUMN `reimburse_pk` varchar(30) NULL COMMENT '报销单pk' AFTER `reimburse_line_num`,
ADD COLUMN `reimburse_money` decimal(28,8) NULL COMMENT '报销金额' AFTER `reimburse_pk`,
ADD COLUMN `income_ex_item_key` varchar(100) NULL COMMENT '收支项目key' AFTER `reimburse_money`,
ADD COLUMN `income_ex_item_val` varchar(100) NULL COMMENT '收支项目值' AFTER `income_ex_item_key`;
其中t_order是本例要修改的表,corp_name是要将新添加的第一列reimburse_num创建在列名为corp_name的列后面,corp_name是本例中的位置参照列