MySQL学习笔记

mysql服务器安装配置：
1. sudp apt-get install mysql-server-5.0
2. 创建库second_proxy, 为secProxy添加用户：grant all privileges on second_proxy.* to secProxy@'%' identified by 'passwd';
3. 设置mysql.user表如下：
+-----------+------------------+-------------------------------------------+
| Host      | User             | Password                                  |
+-----------+------------------+-------------------------------------------+
| %         | root             | *D0CC270F9B91B4CF3D13B5D56E1E52A9F7C001B1 |
| localhost | debian-sys-maint | *F6484D4F45B78E2CE99845B5D54DED451834E427 |
| %         | secProxy         | *B67F64B96B21AA1CDEE83C49A6DB23837F095FD9 |
+-----------+------------------+-------------------------------------------+
临时数据：localhost    | root             | *D0CC270F9B91B4CF3D13B5D56E1E52A9F7C001B1 |
4. sudo vim /etc/mysql/my.cnf, 修改bind-address = 0.0.0.0
5. 重起sudo /etc/init.d/mysql restart
报表事例:
http://dev.mysql.com/tech-resources/articles/ddws/index.html
http://www.gizmola.com/blog/archives/63-PHPlot,-MySQL-and-the-Dark-Ages-of-Camelot.html
查询一天：
select * from table where to_days(column_time) = to_days(now());
select * from table where date(column_time) = curdate();
查询一周：
select * from table  where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(column_time);
查询一个月：
select * from table  where DATE_SUB(CURDATE(), INTERVAL INTERVAL 1 MONTH) <= date(column_time);
以每十分钟为一组
set @t