每日订单金额--create vieworder _ day _ amountasselectfrom _ UNIX time (ctime，' %Y-%m-%d ' ) AS order_day， sum(order_amount )/100 as合计from ) shop_order ) group by order _ dayhavingorder _ day from _ nix time () UNIX _ times ssses
selectfrom_UNIXtime(ctime，' %Y-%m-%d ' ) AS order_day，sum ) order_amount )/100 AS的合计from`shop_order