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ì)本站的支持！
標(biāo)簽：東莞 潛江 南昌 長(zhǎng)沙 武漢 合肥 吉安 江門
巨人網(wǎng)絡(luò)通訊聲明：本文標(biāo)題《mysql 獲取規(guī)定時(shí)間段內(nèi)的統(tǒng)計(jì)數(shù)據(jù)》，本文關(guān)鍵詞 mysql,獲取,規(guī)定,時(shí)間段,；如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問(wèn)題，煩請(qǐng)?zhí)峁┫嚓P(guān)信息告之我們，我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò)，涉及言論、版權(quán)與本站無(wú)關(guān)。
