技术文章 > 后端开发 > php教程
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问题在那