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