mysql 批量插入 查询结果_mysql批量插入查询结果_wcdunf的博客-CSDN博客

网站介绍:文章浏览阅读1k次。INSERT INTO `m-auth`.`user_map_system_user` ( `system_code`, `user_id`, `click_number`, `click_time`, `order_sort`, `update_time` ) SELECT'm-accounting-integration',t.user_id,0,NOW(),1,NOW() FROM `m-auth`.`user_map_system_user` t WHERE t.syste.._mysql批量插入查询结果