UPDATE t1 JOIN ( SELECT buyDate, bookId, COUNT(1) bookCount FROM t2 GROUP BY buyDate, bookId ) t3 ON t1.buyDate = t3.buyDate AND t1.bookId = t3.bookId SET t1.bookCount = t1.bookCount + t3.bookCount -- WHERE ...
56,677
社区成员
56,708
社区内容
加载中
试试用AI创作助手写篇文章吧