MySQL 每小時的數據資料統計

範例：找出 my_table 資料表每小時的資料統計


select hour(my_timeStamp) as hour, count(1) as count from my_table where DATE_FORMAT(my_timestamp, '%Y-%m-%d') = '2012-06-11' group by hour(my_timestamp);