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

2025-01-02 07:18:08
推荐回答(3个)
回答1:

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

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

回答2:

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

回答3:

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