[6344] % mysql -u root benngosi_twitter -e 'SELECT DATE(tw_date), COUNT(*) FROM tw_user_tweet WHERE user LIKE "Hideo_Ogura" GROUP BY DATE(tw_date)\G'|grep -
B2 '(\*): [1-9][0-9][0-9]'
*************************** 1051. row ***************************
DATE(tw_date): 2013-11-04
COUNT(*): 125
--
*************************** 1976. row ***************************
DATE(tw_date): 2016-09-18
COUNT(*): 134
--
*************************** 2039. row ***************************
DATE(tw_date): 2016-11-20
COUNT(*): 203
*************************** 2040. row ***************************
DATE(tw_date): 2016-11-21
COUNT(*): 192
*************************** 2041. row ***************************
DATE(tw_date): 2016-11-22
COUNT(*): 153
*************************** 2042. row ***************************
DATE(tw_date): 2016-11-23
COUNT(*): 294
*************************** 2043. row ***************************
DATE(tw_date): 2016-11-24
COUNT(*): 113
--
*************************** 2046. row ***************************
DATE(tw_date): 2016-11-27
COUNT(*): 128
--
*************************** 2226. row ***************************
DATE(tw_date): 2017-05-28
COUNT(*): 103
0 件のコメント:
コメントを投稿