[6343]  % mysql -u root benngosi_twitter -e 'SELECT DATE(tw_date), COUNT(*) FROM tw_user_tweet WHERE user LIKE "fukazawas" GROUP BY DATE(tw_date)\G'|grep -B2
 '(\*): [1-9][0-9][0-9]'
*************************** 937. row ***************************
DATE(tw_date): 2016-02-24
     COUNT(*): 116
--
*************************** 953. row ***************************
DATE(tw_date): 2016-03-11
     COUNT(*): 166
--
*************************** 1267. row ***************************
DATE(tw_date): 2017-01-19
     COUNT(*): 102
--
*************************** 1294. row ***************************
DATE(tw_date): 2017-02-15
     COUNT(*): 113
--
*************************** 1299. row ***************************
DATE(tw_date): 2017-02-20
     COUNT(*): 101
--
*************************** 1310. row ***************************
DATE(tw_date): 2017-03-03
     COUNT(*): 173
--
*************************** 1321. row ***************************
DATE(tw_date): 2017-03-14
     COUNT(*): 113
--
*************************** 1383. row ***************************
DATE(tw_date): 2017-05-15
     COUNT(*): 106
 
 
0 件のコメント:
コメントを投稿