update orderby limit,时间减一天
UPDATE User SET ADDTIME = DATE_SUB(CURDATE(), INTERVAL 1 DAY) WHERE UserID = '1001' ORDER BY ADDTIME DESC LIMIT 1;
http://dev.mysql.com/doc/refman/5.5/en/update.html
update orderby limit,时间减一天
UPDATE User SET ADDTIME = DATE_SUB(CURDATE(), INTERVAL 1 DAY) WHERE UserID = '1001' ORDER BY ADDTIME DESC LIMIT 1;
http://dev.mysql.com/doc/refman/5.5/en/update.html