例：
SELECT DATE_FORMAT(`create_time`, '%Y-%m-%d') AS days,COUNT(1) AS num FROM `dc_loan_aa_orders` GROUP BY DATE_FORMAT(`create_time`, '%Y-%m-%d') ORDER BY create_time DESC
SELECT DATE_FORMAT(`create_time`, '%Y-%m-%d') A
阅读背景：
mysql按天数据统计
来源：互联网
分享到：
