mysql统计单日数据量

SELECT address,count(*) FROM `anqi` WHERE time='2022-02-13' group by code 

SELECT address,count(*) FROM `anqi` group by code

SELECT * FROM `拍照` WHERE date_format(time,'%Y-%m-%d') = "2022-02-13"