mysql 时间间隔分组_mysql – 在一个时间范围内分组到5分钟的间隔

我有一些困难与mySQL命令，我想做。

SELECT a.timestamp, name, count(b.name)

FROM time a, id b

WHERE a.user = b.user

AND a.id = b.id

AND b.name = 'John'

AND a.timestamp BETWEEN '2010-11-16 10:30:00' AND '2010-11-16 11:00:00'

GROUP BY a.timestamp

这是我当前的输出语句。

timestamp name count(b.name)

------------------- ---- -------------

2010-11-16 10:32:22 John 2

2010-11-16 10:35:12 John 7

2010-11-16 10:36:34 John 1

2010-11-16 10:37:45 John 2

2010-11-16 10:48:26 John 8

2010-11-16 10:55:00 John 9

2010-11-16 10:58:08 John 2

如何将它们分组为5分钟间隔结果？

我想让我的输出像

timestamp name count(b.name)

------------------- ---- -------------

2010-11-16 10:30:00 John 2

2010-11-16 10:35:00 John 10

2010-11-16 10:40:00 John 0

2010-11-16 10:45:00 John 8

2010-11-16 10:50:00 John 0

2010-11-16 10:55:00 John 11