mysql高效查询某一天数据
yu_timothy | 314 |
2023-07-06 select *
from wms_warehouse_order
where created_time between str_to_date('2023-06-01', '%Y-%m-%d') and str_to_date('2023-07-01', '%Y-%m-%d')
等号左边不使用函数，高效利用索引
推荐指数：
真诚点赞 诚不我欺~
yu_timothy | 314 |
2023-07-06 select *
from wms_warehouse_order
where created_time between str_to_date('2023-06-01', '%Y-%m-%d') and str_to_date('2023-07-01', '%Y-%m-%d')
等号左边不使用函数，高效利用索引
真诚点赞 诚不我欺~
这个人很懒~
等级 LV1
粉丝 0
获赞 0
经验 11