-- 表结构
/*
id int,
strA varchar(50),
createDate datetime
*/-- 数据
/*
1 A1 2012-07-19 11:52:14
2 A2 2012-07-19 11:59:17
3 A3 2012-07-19 13:11:22
4 A4 2012-07-21 13:12:15
5 A5 2012-07-21 18:08:54
6 A6 2012-07-23 08:09:31
7 A7 2012-07-30 21:37:38
8 A8 2012-07-30 22:04:32
9 A9 2012-07-30 22:17:04
10 A10 2012-07-31 14:37:38
*/-- 要求生成如下格式:
/*
日期 访问次数
2012-07-19 3
2012-07-21 2
2012-07-23 1
2012-07-30 3
2012-07-31 1
*/
/*
id int,
strA varchar(50),
createDate datetime
*/-- 数据
/*
1 A1 2012-07-19 11:52:14
2 A2 2012-07-19 11:59:17
3 A3 2012-07-19 13:11:22
4 A4 2012-07-21 13:12:15
5 A5 2012-07-21 18:08:54
6 A6 2012-07-23 08:09:31
7 A7 2012-07-30 21:37:38
8 A8 2012-07-30 22:04:32
9 A9 2012-07-30 22:17:04
10 A10 2012-07-31 14:37:38
*/-- 要求生成如下格式:
/*
日期 访问次数
2012-07-19 3
2012-07-21 2
2012-07-23 1
2012-07-30 3
2012-07-31 1
*/
select thisDate, count(*) from (
select date(createDate) as thisDate from 表
) as T group by thisDate order by thisDate;
from 表
group by left(createDate, 10)
from tb
group by date(createDate)
FROM tb
GROUP BY DATE(createDate);
FROM 表结构
GROUP BY DATE(createDate);