语法格式:
删除全部:DELETEFROM 表名称
删除局部:DELETE FROM 表名称 WHERE 删除条件
-- 1 删除编号是7369的雇员信息
delete from myemp where empno = '7369';
-- 2 删除编号是7654,7698,7782,7788,7839的雇员信息
delete from myemp where empno in ('7654', '7698', '7782', '7788', '7839');
-- 3 删除全部领取奖金的雇员信息
delete from myemp where comm is not null;
-- 4 删除表中的全部内容
delete from myemp;