Mysql obtains statistics for a specified period of time. mysql statistics

Mysql obtains statistics for a specified period of time. mysql statistics

Mysql obtains statistics within a specified period of time.

By year

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 ') = '20140901' group by count_by_date ORDER BY NULL

Monthly Statistics

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 ') = '2014-04 'group by count_by_date ORDER BY NULL

Specific changes can be changed as needed

Thank you for reading this article. I hope it will help you. Thank you for your support for this site!