《MYSQL數(shù)據(jù)庫mysql 獲取規(guī)定時間段內(nèi)的統(tǒng)計數(shù)據(jù)》要點(diǎn)：
本文介紹了MYSQL數(shù)據(jù)庫mysql 獲取規(guī)定時間段內(nèi)的統(tǒng)計數(shù)據(jù)，希望對您有用。如果有疑問，可以聯(lián)系我們。

MYSQL教程mysql 獲取規(guī)定時間段內(nèi)的統(tǒng)計數(shù)據(jù)

MYSQL教程按年統(tǒng)計

MYSQL教程
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 

MYSQL教程按月統(tǒng)計

MYSQL教程
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 

MYSQL教程具體變換可以自己根據(jù)需求變更

MYSQL教程感謝閱讀,希望能贊助到大家,謝謝大家對本站的支持!

歡迎參與《MYSQL數(shù)據(jù)庫mysql 獲取規(guī)定時間段內(nèi)的統(tǒng)計數(shù)據(jù)》討論，分享您的想法，維易PHP學(xué)院為您提供專業(yè)教程。

轉(zhuǎn)載請注明本頁網(wǎng)址：
http://www.snjht.com/jiaocheng/11249.html