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");
原文：http://www.cnblogs.com/xihong2014/p/5701560.html