[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 件のコメント:
コメントを投稿