Mysql获取当前时间的前几天和字段中的时间进行比较
时间:2016-05-08 12:13 来源:linux.it.net.cn 作者:IT
DELETE FROM zhongqiu WHERE caretatime<=ADDDATE(NOW(),-14)
caretatime字段为时间字段
`caretatime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-14为14天以前
(责任编辑：IT)
| DELETE FROM zhongqiu WHERE caretatime<=ADDDATE(NOW(),-14) caretatime字段为时间字段 `caretatime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, -14为14天以前 (责任编辑：IT) |