Mysql 常用技巧 （连载）

1.巧用sum（）函数

+---------------------+---------+
| date                | victory |
+---------------------+---------+
| 2006-05-21 00:00:00 | 败      |
| 2006-05-22 00:00:00 | 胜      |
| 2006-05-21 00:00:00 | 胜      |
| 2006-05-22 00:00:00 | 败      |
| 2006-05-21 00:00:00 | 败      |
| 2006-05-22 00:00:00 | 胜      |
+---------------------+---------+
查询转换成

+---------------------+---------+------+
| date                | victory | fail |
+---------------------+---------+------+
| 2006-05-21 00:00:00 |       1 |    2 |
| 2006-05-22 00:00:00 |       2 |    1 |
+---------------------+---------+------+

mysql> select date,sum(victory='胜') as victory ,sum(victory='败') as fail from text group by date;