根据条件查找表中的数据,删除表中的数据
select * from tab01 where grade between 80 and 100;
select * from tab01 where id in(3,6,9);
show variables like 'sql_safe_updates' ; set sql_safe_updates=0; #关闭状态 set sql_safe_updates=1; #打开状态
delete from tab01 where id >10;
delete from tab01 where grade<60;