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

來(lái)源：懂視網(wǎng) 責(zé)編：小采時(shí)間：2020-11-09 20:34:12

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

mysql獲取規(guī)定時(shí)間段內(nèi)的統(tǒng)計(jì)數(shù)據(jù):mysql 獲取規(guī)定時(shí)間段內(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

推薦度：

點(diǎn)擊下載本文 文檔為doc格式

導(dǎo)讀mysql獲取規(guī)定時(shí)間段內(nèi)的統(tǒng)計(jì)數(shù)據(jù):mysql 獲取規(guī)定時(shí)間段內(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

mysql 獲取規(guī)定時(shí)間段內(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ù)需求變更

感謝閱讀，希望能幫助到大家，謝謝大家對(duì)本站的支持！