hualingkai11的博客

1.创建一个基础表DROP TABLE IF EXISTS `num`;CREATE TABLE `num` ( `i` int(11) DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;-- ------------------------------ Records of num-- -----------------...

过去一小时 SELECT * FROM table WHERE user_time BETWEEN DATE_SUB(NOW(),INTERVAL 1 HOUR) and NOW()当天到目前为止SELECT * FROM table WHERE DATE(user_time) = curdate()昨天SELECT * FROM table WHERE DATEDIF...