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)