删除数据

语法格式:

delete from 表名 where 条件;

注意:没有条件全部删除

删除10部门数据?

delete from dept where deptno = 10;

删除所有数据?

delete from dept;

怎么删除大表?(重点:表被截断,不可回滚,无法恢复)

truncate table dept