//sys_dept表和sys_dict 关联,更新sys_dept表dwxz_code字段
UPDATE sys_dept a INNER JOIN (SELECT name,VALUE FROM sys_dict WHERE type='sys_dept') b ON a.dwxz=b.`name` SET dwxz_code=b.`VALUE`
根据连表语句查询,更新相应的字段//sys_dept表和sys_dict 关联,更新sys_dept表dwxz_code字段UPDATE sys_dept a INNER JOIN (SELECT name,VALUE FROM sys_dict WHERE type='sys_dept') b ON a.dwxz=b.`name` SET dwxz_code=b.`VALUE...