一条SQL取出今天、昨天、本月的数据不知可否? 大概为:pdate pcount2009-06-05 112009-06-05 212009-06-06 122009-06-06 322009-06-07 562009-06-07 26我想一条SQL取出今天、昨天、本月的数据不知可有办法?如今天浏览 82 昨天44 本月189 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 你提供的例子并不准确,今天已经是 2009-06-13 了mysql> select * from tx;+------------+--------+| pdate | pcount |+------------+--------+| 2009-06-05 | 11 || 2009-06-05 | 21 || 2009-06-06 | 12 || 2009-06-06 | 32 || 2009-06-07 | 56 || 2009-06-07 | 26 |+------------+--------+6 rows in set (0.00 sec)mysql> select '今天',sum(pcount) from tx where pdate=CURDATE() -> union all -> select '昨天',sum(pcount) from tx where pdate=DATE_SUB(CURDATE(),INTERVAL 1 DAY) -> union all -> select '本月',sum(pcount) from tx where pdate>DATE_SUB(CURDATE(),INTERVAL DAYOFMONTH(CURDATE())-1 DAY) ;+------+-------------+| 今天 | sum(pcount) |+------+-------------+| 今天 | NULL || 昨天 | NULL || 本月 | 158 |+------+-------------+3 rows in set (0.00 sec)mysql> 或者如下mysql> select sum(if(pdate=CURDATE(),pcount,0)) as '今天', -> sum(if(pdate=DATE_SUB(CURDATE(),INTERVAL 1 DAY),pcount,0)) as '昨天', -> sum(pcount) as '本月' -> from tx -> where pdate>DATE_SUB(CURDATE(),INTERVAL DAYOFMONTH(CURDATE())-1 DAY) ;+------+------+------+| 今天 | 昨天 | 本月 |+------+------+------+| 0 | 0 | 158 |+------+------+------+1 row in set (0.00 sec)mysql> navicat中文乱码的问题??? 诚心请教一个问题,关于数据库编程,关于线程安全 【mysql full join】 【问题】 mysql 中使用not in 后为啥更慢了... mysqlbinlog 恢复 如何判断一个mysql表的类型 MYSQ数据库中字段属性问题,巨easy,关注一下 mysql中插入一条记录时成功后字段值中的内容会自动去掉最后一位,怎么处理? 请把以下php正则修改为mysql正则 mysql 有http 协议,什么情况? 急急急!用工具将Oracle转换为mysql后中文乱码无法消除? 如何让mysql结束一个对五千万条记录的查询
+------------+--------+
| pdate | pcount |
+------------+--------+
| 2009-06-05 | 11 |
| 2009-06-05 | 21 |
| 2009-06-06 | 12 |
| 2009-06-06 | 32 |
| 2009-06-07 | 56 |
| 2009-06-07 | 26 |
+------------+--------+
6 rows in set (0.00 sec)mysql> select '今天',sum(pcount) from tx where pdate=CURDATE()
-> union all
-> select '昨天',sum(pcount) from tx where pdate=DATE_SUB(CURDATE(),INTERVAL 1 DAY)
-> union all
-> select '本月',sum(pcount) from tx where pdate>DATE_SUB(CURDATE(),INTERVAL DAYOFMONTH(CURDATE())-1 DAY) ;
+------+-------------+
| 今天 | sum(pcount) |
+------+-------------+
| 今天 | NULL |
| 昨天 | NULL |
| 本月 | 158 |
+------+-------------+
3 rows in set (0.00 sec)mysql>
-> sum(if(pdate=DATE_SUB(CURDATE(),INTERVAL 1 DAY),pcount,0)) as '昨天',
-> sum(pcount) as '本月'
-> from tx
-> where pdate>DATE_SUB(CURDATE(),INTERVAL DAYOFMONTH(CURDATE())-1 DAY) ;
+------+------+------+
| 今天 | 昨天 | 本月 |
+------+------+------+
| 0 | 0 | 158 |
+------+------+------+
1 row in set (0.00 sec)mysql>