.jpg)
這篇文章主要介紹了mysql 獲取規(guī)定時間段內(nèi)的統(tǒng)計(jì)數(shù)據(jù)的相關(guān)資料,需要的朋友可以參考下
mysql 獲取規(guī)定時間段內(nèi)的統(tǒng)計(jì)數(shù)據(jù)
按年統(tǒng)計(jì)
SELECT? ??count(*),? ??DATE_format(order_info.create_time,?'%Y-%m-%d')?AS?count_by_date? FROM? ??order_info? WHERE? ??DATE_FORMAT(order_info.create_time,?'%Y')?=?'2017'? GROUP?BY? ??count_by_date? ORDER?BY?NULL
按月統(tǒng)計(jì)
SELECT? ??count(*),? ??DATE_FORMAT(order_info.create_time,?'%Y-%m-%d')?AS?count_by_date? FROM? ??order_info? WHERE? ??DATE_FORMAT(order_info.create_time,?'%Y-%m')?=?'2017-04'? GROUP?BY? ??count_by_date? ORDER?BY?NULL
具體變換可以自己根據(jù)需求變更
? 版權(quán)聲明
文章版權(quán)歸作者所有，未經(jīng)允許請勿轉(zhuǎn)載。
THE END
.png)
