between DATE_FORMAT(curdate(), '%Y-%m-%d %H:%i:%s')
and DATE_FORMAT(date_sub(curdate(), interval -1 day), '%Y-%m-%d %H:%:%s')
mysql查询datetime字段当天数据,使用索引
最新推荐文章于 2024-05-06 10:39:48 发布
between DATE_FORMAT(curdate(), '%Y-%m-%d %H:%i:%s')
and DATE_FORMAT(date_sub(curdate(), interval -1 day), '%Y-%m-%d %H:%:%s')