sql语句的使用

删除id 号不连续的三个记录

delete from student where id in ('1','4','6');
或

delete from student where id='1' or id='4' or id='6'
如果id是数字类型的就不用加单引号