DELETE FROM month_test WHERE date_dt < DATE_SUB(NOW(),INTERVAL 1 MONTH)mysql> select now();+---+ | now() | +---+ | 2011-09-01 16:32:01 | +---+ 1 row in set (0.27 sec)mysql> select DATE_SUB(-> NOW(),-> INTERVAL 1 MONTH)-> ;+---...
求sql一条，是在mysql中删除一个月前的数据
DELETE FROM month_test
WHERE date_dt < DATE_SUB(
NOW(),
INTERVAL 1 MONTH)
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2011-09-01 16:32:01 |
+---------------------+
1 row in set (0.27 sec)
mysql> select DATE_SUB(
-> NOW(),
-> INTERVAL 1 MONTH)
-> ;
+------------------------------------------------------+
| DATE_SUB(
NOW(),
INTERVAL 1 MONTH) |
+------------------------------------------------------+
| 2011-08-01 16:32:23 |
+------------------------------------------------------+
1 row in set (0.01 sec)2011-09-01
date_dt between (now-1month,now-2month)2011-09-01
delete month_test where datediff(now(), date_dt) > 30;2011-09-01
