[6345] % mysql -u root benngosi_twitter -e 'SELECT DATE(tw_date), COUNT(*) FROM tw_user_tweet WHERE user LIKE "motoken_tw" GROUP BY DATE(tw_date)\G'|grep -B
2 '(\*): [1-9][0-9][0-9]'
*************************** 389. row ***************************
DATE(tw_date): 2011-08-06
COUNT(*): 115
--
*************************** 589. row ***************************
DATE(tw_date): 2012-03-16
COUNT(*): 129
--
*************************** 1688. row ***************************
DATE(tw_date): 2016-02-23
COUNT(*): 149
*************************** 1689. row ***************************
DATE(tw_date): 2016-02-24
COUNT(*): 121
--
*************************** 1693. row ***************************
DATE(tw_date): 2016-02-28
COUNT(*): 155
--
*************************** 1697. row ***************************
DATE(tw_date): 2016-03-03
COUNT(*): 101
--
*************************** 1777. row ***************************
DATE(tw_date): 2016-05-22
COUNT(*): 102
--
*************************** 1897. row ***************************
DATE(tw_date): 2016-09-19
COUNT(*): 112
--
*************************** 1936. row ***************************
DATE(tw_date): 2016-10-28
COUNT(*): 121
--
*************************** 1987. row ***************************
DATE(tw_date): 2016-12-18
COUNT(*): 177
0 件のコメント:
コメントを投稿