ALTER TABLE `t_ba_zxzybaydwjbxx`
ADD COLUMN `orgName`  varchar(200) NULL COMMENT '所属机构' AFTER `comId`;

update t_ba_zxzybaydwjbxx t1,t_org t2
set t1.orgName=t2.orgname
where t1.slbagajg=t2.orgcode;