Tutorial on how to obtain statistical data within a specified time period using mysql

This article mainly introduces the relevant information about mysql obtaining statistical data within a specified time period. Friends who need it can refer to it. I hope it can help everyone.

mysql Get statistical data within a specified time period

Statistics 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') = '2017' 
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') = '2017-04' 
GROUP BY 
  count_by_date 
ORDER BY NULL

The specific transformation can be changed according to your needs.

Related recommendations:

Statistical database daily data growth

##SQL statement skills: monthly statistics

Oracle Optimization Statistics Histograms

The above is the detailed content of Tutorial on how to obtain statistical data within a specified time period using mysql. For more information, please follow other related articles on the PHP Chinese website!