Swime的博客

假设access_log表有src_ip、user_agent、url三个字段，每一次请求产生一条记录(行)，现在想统计访问量前10的IP、访问量count及访问量占比percent第一种方式：直接从多个表查询数据SELECT a.src_ip, a.count, round(a.count * 100 / b.total, 2) as percentFROM ( SELECT src_ip, count() as count FROM