Mysql查询同一天的多条数据相加

SELECT DATE(tradingTime) AS date, SUM(transactionAmount) AS amoutFROM 表名 GROUP BY DATE(tradingTime)

请运行下列sql更新语句：

update B,

(select sum(金额) as n from A

where 状态='F' and 时间<now()) t

set B.总金额=t.n

---