sql数据库高效多表删除语句

1. 删除一个表中的数据
delete from department where name='Asset Management';

2. 删除两个表中的数据
delete employee, employeeSkills
from employee, employeeSkills, department
where employee.employeeID = employeeSkills.employeeID
and employee.departmentID = department.departmentID
and https://www.doczj.com/doc/95374283.html,='Finance';

3. 删除两个表中的数据,用using语法
delete from employee, employeeSkills
using employee, employeeSkills, department
where employee.employeeID = employeeSkills.employeeID
and employee.departmentID = department.departmentID
and https://www.doczj.com/doc/95374283.html,='Finance';