delete删除多表

1、DELETE a.*, aa.* FROM student a, person aa WHERE a.id = aa.city_id AND a.name = ''

2、DELETE a.*, aa.* FROM student a inner join person aa on a.id = aa.city_id WHERE a.name = ''

3、DELETE a.*, aa.* FROM student a left join person aa on a.id = aa.city_id WHERE a.name = ''

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/loweringye/p/5841316.html