mysql : delete old data DATE_ADD()

[admin]

程式碼:
DELETE table1 WHERE sdate < DATE_ADD(NOW(), INTERVAL -2 MONTH);

MICROSECOND
SECOND
MINUTE
HOUR
DAY
WEEK
MONTH
QUARTER
YEAR


this sql will delete 2 month ago records