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...