按每个月分组统计数据
# 按每个月分组统计数据
select COUNT(*),时间列from 表 where year(时间列) = '2022' group by month(时间列)
# 范围查询
select * from qa5_fo.nw_power_scan_1 order by id desc limit 20, 10 ;
#详细信息
select table_schema,table_name,table_type,table_rows from information_schema.tables where table_schema='库' and table_name='表';
# 时间范围查询
SELECT * FROM analysis.power_scan_log_path where file_create_time > '2022-08-01' AND file_create_time < '2022-08-15';