select DATE_FORMAT( deteline, "%Y-%m-%d %H" ) , COUNT( * ) FROM test GROUP BY DATE_FORMAT( deteline, "%Y-%m-%d %H" )
posted on 2018-02-05 13:54 范兵 阅读(845) 评论(0) 编辑 收藏 举报
