select FROM_UNIXTIME(create_time, '%Y-%m-%d') as dd, sum(shop_good_price) as count from drink_sold_goods where sold_status="已支付" GROUP BY FROM_UNIXTIME(create_time, '%Y-%m-%d');
mysql根据每天分组sql语句
最新推荐文章于 2024-07-03 03:16:50 发布