delete 删除数据
语法格式: DELETE FROM 表名 WHERE 条件限制;
注意:若没有条件限制,会将表中所有记录全部删除;
示例一:将 t_student 表中 no 为 3的学生删除
delete from t_student where no = 3;
示例二:将 t_student 表中的数据全部删除
delete from t_student;
将 emp_bak 表中部门编号为20的 MANAGER 删除掉;
delete from emp_bak where deptno = 20 and job = 'MANAGER';