同时删除多张关联表中的记录:
delete a.*,b.*,c.*,d.*
from aa a
LEFT JOIN bb b on a.id = b.res_id
LEFT JOIN cc c on c.id = a.id
LEFT JOIN dd d on a.id = d.id
where a.xx = #{xxx} and a.yy = #{yyy}
mysql 中删除多张表
最新推荐文章于 2024-06-06 10:50:24 发布