mysql数据库表添加列的语句(例子)

 

 

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是本例中的位置参照列