如何从mysql数据库中获取每小时数据

Question

我必须根据日期时间每小时从数据库中获取数据，我试过了，但没有得到这样的想法：..I是sql的新成员，您能帮我吗？我正试图在一小时内为特定用户获取数据，他执行了多少次操作？

select username,count(message) as '8-9',count(message) as '9-10',count(message) as '10-11'
from customer_1.audit_trail 
inner join inteliviz.user on customer_1.audit_trail.user_id = inteliviz.users.id 
where datetime>'2013-08-21 08:00:00' and datetime<'2013-08-21 09:00:00'
group by username  limit 1000;

Answer 1

在之间的使用

select username,count(message) as '8-9',count(message) as '9-10',count(message) as '10-11'
from customer_1.audit_trail 
inner join inteliviz.user on customer_1.audit_trail.user_id = inteliviz.users.id 
where datetime between '2013-08-21 08:00:00' and '2013-08-21 09:00:00'
group by username  limit 1000;