DELETE语句 DELETE语句用于删除记录,语法如下: DELETE [IGNORE] FROM 表名 [WHERE 条件1,条件2,...] [ORDER BY...] [LIMIT...]; 练习 删除10部门中,工龄超过20年的员工记录 delete from t_emp where deptno=10 and datediff(now(),hiredate)/365>20; 删除20部门中工资最高的员工记录 delete from