INSERT
INTO
tb_user_enable_status(user_id,create_time,total)
(SELECT
user_id,date_format(#{createTime}(这个是在表tb_book_operation中没有的字段),'%Y-%m-%d') AS create_time,count(book_id)
AS total FROM
tb_book_operation
WHERE
operation_status=3 GROUP BY user_id)
sql 嵌套使用select
最新推荐文章于 2023-08-25 15:29:01 发布