<!-- 按日查询 --> select INTERFACE_NAME,DATE_FORMAT(INITIATION_TIME,'%Y-%m-%d') as time,count(*) from ps_interface_call_log where REQUEST_IP like '10.110.4%' AND INITIATION_TIME > '2020-03-01 00:00:00' group by INTERFACE_NAME,time order by time desc <!-- 按月查询 --> select INTERFACE_NAME,DATE_FORMAT(INITIATION_TIME,'%Y-%m') as time,count(*) from ps_interface_call_log where REQUEST_IP like '10.110.4%' AND INITIATION_TIME > '2020-03-01 00:00:00' group by INTERFACE_NAME,time order by time desc <!-- 按年查询 --> select INTERFACE_NAME,DATE_FORMAT(INITIATION_TIME,'%Y') as time,count(*) from ps_interface_call_log where REQUEST_IP like '10.110.4%' AND INITIATION_TIME > '2020-03-01 00:00:00' group by INTERFACE_NAME,time order by time desc <!-- 按周查询 --> select INTERFACE_NAME,DATE_FORMAT(INITIATION_TIME,'%Y-%u') as time,count(*) from ps_interface_call_log where REQUEST_IP like '10.110.4%' AND INITIATION_TIME > '2020-03-01 00:00:00' group by INTERFACE_NAME,time order by time desc