mysql连表删除

DELETE p from a p inner JOIN b i on p.id=i.pic_id  where ……;

where条件之后随便写