需求:定时删除n天前的数据
DELETE FROM table_name WHERE UNIX_TIMESTAMP(create_time) <= UNIX_TIMESTAMP(DATE_ADD(CURRENT_DATE,INTERVAL -5 DAY));
其中table_为表名,“5”代指“n“
或用如下方法
DELETE FROM table_name where TO_DAYS(NOW())-TO_DAYS(create_time)>5;
其他的就不废话了
需求:定时删除n天前的数据
DELETE FROM table_name WHERE UNIX_TIMESTAMP(create_time) <= UNIX_TIMESTAMP(DATE_ADD(CURRENT_DATE,INTERVAL -5 DAY));
其中table_为表名,“5”代指“n“
或用如下方法
DELETE FROM table_name where TO_DAYS(NOW())-TO_DAYS(create_time)>5;
其他的就不废话了