更新时间:2023-10-10 22:41:22
您还可以使用使用:
使用
DELETE FROM merchant_configurations AS mc USING merchant_configurations AS mc2 LEFT JOIN merchants ON mc2.merchant_id = merchants.id WHERE mc2.id = mc.id AND merchants.id IS NULL
如果关联的联接条目不存在,则删除记录