根据sys_dept与pms_project通过名称关联,补充相关的部门id
UPDATE pms_project,sys_dept
SET pms_project.`apply_dept_id`=sys_dept.`dept_id`
WHERE sys_dept.dept_name=pms_project.apply_dept
根据sys_dept与pms_project通过名称关联,补充相关的部门id
UPDATE pms_project,sys_dept
SET pms_project.`apply_dept_id`=sys_dept.`dept_id`
WHERE sys_dept.dept_name=pms_project.apply_dept