UPDATE dept A
SET parent_depe_name =
(SELECT B.depe_name FROM (SELECT * FROM dept ) B WHERE B.dept_id = A.parent_depe_id)
WHERE A.parent_depe_name IS NULL;
mysql更新部门表的【上级部门名称】字段
最新推荐文章于 2024-06-28 10:10:43 发布
UPDATE dept A
SET parent_depe_name =
(SELECT B.depe_name FROM (SELECT * FROM dept ) B WHERE B.dept_id = A.parent_depe_id)
WHERE A.parent_depe_name IS NULL;