mysql : delete old data DATE

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

文章最後修改資訊: 2025-05-29, 06:53 PM 被 admin.

Users browsing this thread: 1 Guest(s)