【原】MySQL时间戳timestamp比较
摘要：
DROP TABLE IF EXISTS `t`;CREATE TABLE `t` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ts` timestamp , PRIMARY KEY (`id`)) ;INSERT INTO `t` VALUES ('1', '2014-01-06 17:01:36');-- DELETE FROM t WHERE ts < UNIX_TIMESTAMP(CONCAT(DATE_SUB(DATE(NOW()),INTERVAL -3 MONTH ),' ',CURTIM 阅读全文
posted @ 2014-03-06 17:21 longhua828 阅读(4201) 评论(0) 推荐(0) 编辑
