select count() from log where FROM_UNIXTIME(assign_time, ‘%Y%m%d’) = 20190817
会扫全表
select count() from log where assign_time between unix_timestamp(‘2019-08-17’) and (unix_timestamp(‘2019-08-17’)+86399)
会走索引
sql 语句查当天入库了多少条数据
最新推荐文章于 2023-08-29 11:04:24 发布