MySQL 多表关联删除
多张表关联,同时删除多张表数据。
DELETE t1, t2, t3
FROM t1
LEFT JOIN t2 ON(t1.id = t2.id)
LEFT JOIN t3 ON(t1.id = t3.id)
WHERE 条件
多张表关联,同时删除多张表数据。
DELETE t1, t2, t3
FROM t1
LEFT JOIN t2 ON(t1.id = t2.id)
LEFT JOIN t3 ON(t1.id = t3.id)
WHERE 条件