Shulou(Shulou.com)06/01 Report--

Editor to share with you mysql how to obtain statistics within a specified period of time, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Mysql acquires statistical data within a specified period of time

Annual statistics

SELECT count (*), DATE_FORMAT (order_info.create_time,'% YMY% MMI% 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

Monthly statistics

SELECT count (*), DATE_FORMAT (order_info.create_time,'% Ymuri% mmi% d') AS count_by_date FROM order_info WHERE DATE_FORMAT (order_info.create_time,'% Ymuri% m') = '2017-04' GROUP BY count_by_date ORDER BY NULL

The specific changes can be changed according to the requirements.

The above is how mysql obtains all the statistical data within a specified period of time. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.