列印本頁 - mysql : delete old data DATE

標題: mysql : delete old data DATE_ADD()
作者: admin 於 五月 30, 2026, 12:22 AM

程式碼:
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