DELETE FROM zhongqiu WHERE caretatime<=ADDDATE(NOW(),-14)
caretatime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONCAT(serviceDate,
' '
, serviceTime) >=
'2015-09-21 10:26:54'
DATE_FORMAT(ADDDATE(NOW(),INTERVAL 24 HOUR),"%Y-%m-%d %h:%i:%s");
DELETE FROM zhongqiu WHERE caretatime<=ADDDATE(NOW(),-14)
caretatime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONCAT(serviceDate,
' '
, serviceTime) >=
'2015-09-21 10:26:54'
DATE_FORMAT(ADDDATE(NOW(),INTERVAL 24 HOUR),"%Y-%m-%d %h:%i:%s");
转载于:https://www.cnblogs.com/xihong2014/p/5701560.html