delete from 表名 where 字段名 > '2000-08-08' or 字段名 < '2010-02-02'注意 '2000-08-08' 一定要用单引号引起来.. 记得采纳啊
delete from 表名 where 时间字段名 between '2000-01-01' and '2010-01-01'
