摘要: -- 每日单量 select DATE_FORMAT(createtime,'%Y-%m-%d') as days,count(*) count from ibt_shop_order group by days; -- 每周单量 select DATE_FORMAT(createtime,'%Y-%u') as weeks,count(*) count from ibt_shop_order ... 阅读全文
posted @ 2019-04-03 20:05 巴黎夜雨…… 阅读(233) 评论(0) 推荐(0) 编辑