有些同学把这两个连在一起用报错，问题在于，没指定删除a表还是b表数据，MySQL很懵逼
DELETE
a
,b
FROM
bbibm_purchasing_arrival_goods a
left join
bbibm_purchasing_arrival_goods_details b
on
a
.number
=b
.purchasing_arrive_num
WHERE
a
.number
= '2'
批量删除
DELETE FROM TestTable WHERE ID IN
(1, 3, 54, 68)
