DELETE删除记录以及嵌套查询

删除id为001的记录

DELETE FROM table_name WHERE id = 001

删除控制系的所有学生 涉及到嵌套查询

DELETE FROM Student WHERE DNumber IN SELECT DNumber FROM Dept WHERE Dname = "控制系";