求mysql做一个统计语句

Question

本帖最后由 baidu_24155709 于 2014-12-25 09:23:26 编辑

Answer 1

select sum(huahui_shops_products.price) as prices 
   from huahui_shops_orders,huahui_shops_products 
        where huahui_shops_products.oid=huahui_shops_orders.oid  
                group by FROM_UNIXTIME(huahui_shops_orders.stime ,"%d") ; #把时间戳转换成月份
其他细节。你自己再补充哈

Answer 2

group by FROM_UNIXTIME(huahui_shops_orders.stime ,"%c")%d  改成 %c哈。刚搞错了d是 日
c才是月