+- Forums (https://zhtw.com/f)
+-- Forum: 分類 (https://zhtw.com/f/forumdisplay.php?fid=1)
+--- Forum: 程式語言 Programming language (https://zhtw.com/f/forumdisplay.php?fid=9)
+--- Thread: mysql : delete old data DATE_ADD() (/showthread.php?tid=31)
mysql : delete old data DATE_ADD() - admin - 2025-05-29
碼:
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