批量查询更新

--批量查询插入数据
INSERT into dts_user_spread_mark_back (id,product_user_id,create_time) select id,product_user_id,create_time from dts_user_spread_mark


--批量更新数据
UPDATE dts_user_spread_mark_back sm LEFT JOIN dts_user_product_account acc on sm.product_user_id = acc.id set sm.user_id = acc.user_id

posted @ 2022-09-20 11:09  变换  阅读(18)  评论(0编辑  收藏  举报