首页 > 代码库 > delete删除多表

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 = ‘‘

delete删除多表