删除数据
语法格式:
delete from 表名 where 条件;
注意:没有条件全部删除
删除10部门数据?
delete from dept where deptno = 10;
删除所有数据?
delete from dept;
怎么删除大表?(重点:表被截断,不可回滚,无法恢复)
truncate table dept
语法格式:
delete from 表名 where 条件;
注意:没有条件全部删除
删除10部门数据?
delete from dept where deptno = 10;
删除所有数据?
delete from dept;
truncate table dept