mysql 更新问题
UPDATE cg_disease_department AS a SET a.department_id =
SELECT department_id FROM cg_department AS b WHERE a.department_name = b.name
我的需求是 将b表的departmentid 更新到 a表的departmentid 条件是 a.department_name = b.name
我这sql问题在那
已抢66413个
抢已抢36970个
抢已抢20507个
抢已抢2515个
抢已抢18963个
抢