Mysql 查询 Select 语句需要帮助

Question

我有一个 mysql 查询，我可以在其中获取总销售额是多少，

但它显示之前的日期 [Date] => 2014-01-22 [TotalSales] => 7 ,

它是这样显示的，我该如何制作，以便它显示今天的日期并显示到目前为止的销售

 SELECT DATE(order_time) AS Date, SUM(Quantity) AS TotalSales
 FROM ss_orders,ss_ordered_carts
 GROUP BY date;

Answer 1

然后添加一个 where 子句，将您的 order_time 与今天的日期进行比较。像这样:

SELECT DATE(order_time) AS Date, SUM(Quantity) AS TotalSales
        FROM ss_orders,ss_ordered_carts
        WHERE DATE(order_time) = DATE(NOW())
         group by date;