Question

如何删除SQL表中某时间段的记录

删除SQL NEWS 表中 adddate(添加时间）2009年6月1日前的数据，这个SQL语句怎么写啊？

Answer 1

delete from NEWS where adddate < '2009-6-1'

删除时间段delete from NEWS where adddate between '1900-01-01' and '200--06-01'

Answer 2

delete from NEWS where adddate < '2009-6-1'

Answer 3

delete from news where adddate<'2009-06-01';