删除id为001的记录
DELETE FROM table_name
WHERE id = 001
删除控制系的所有学生
涉及到嵌套查询
DELETE FROM Student WHERE DNumber IN
SELECT DNumber FROM Dept WHERE Dname = "控制系";
删除id为001的记录
DELETE FROM table_name
WHERE id = 001
删除控制系的所有学生
涉及到嵌套查询
DELETE FROM Student WHERE DNumber IN
SELECT DNumber FROM Dept WHERE Dname = "控制系";