mysql服务器取数笔记

对2013年200天的数据分析：

去数据平稳的六月份的20-25号数据分析：可以看到数据成周期变化，

mysql提取数据保存：

select

lac,cellci,servicename,sum(spd_avg_bytes),s_year,s_month,s_day

from

lv_ipsession_all

where

s_year = 2013 and s_month=6 and s_day between 20 and 25 andservicename='QQ' group by

lac,s_day

order by

lac, s_day

into outfile '/tmp/QQlac20130620_25.csv'character set utf8 fields terminated by ',' lines terminated by '\n';