mysql 单表、多表删除的两种关联删除方式

1、单表删除两种关联方式

关联方式1：基本语法

DELETE t1 FROM t1,t2 WHERE ...

关联方式1：案例应用

delete a from sale_so_bill a, sale_so_bill_detail b
where a.co_id = b.co_id and a.bill_no = b.bill_no and b.ckbill_no = 'SW201901040002'

关联方式2：基本语法

DELETE FROM t1 USING t1,t2 WHERE ...

关联方式2：案例应用，注意表别名的应用，可以使sql更简洁

delete from a using sale_so_bill a, sale_so_bill_detail b
where a.co_id = b.co_id and a.bill_no = b.bill_no and b.ckbill_no = 'SW201901040002'

2、多表删除

关联方式1：基本语法

DELETE t1,t2 FROM t1,t2,t3 WHERE ...

关联方式1：案例应用

delete a,b from sale_so_bill a, sale_so_bill_detail b
where a.co_id = b.co_id and a.bill_no = b.bill_no and b.ckbill_no = 'SW201901040002'

关联方式2：基本语法

DELETE FROM t1,t2 USING t1,t2,t3 WHERE ...

关联方式2：案例应用，注意表别名的应用，可以使sql更简洁

delete from a,b using sale_so_bill a, sale_so_bill_detail b
where a.co_id = b.co_id and a.bill_no = b.bill_no and b.ckbill_no = 'SW201901040002'