insert into sys_user_post (user_id,post_id)
select
q3.user_id,q2.post_id
from apost_excel q1
LEFT JOIN sys_post q2 on q1.post_name=q2.post_name
LEFT JOIN sys_user q3 on q1.user_name=q3.nick_name
where q3.user_id is not null
mysql通过查询结果插入表数据
于 2023-10-13 15:52:47 首次发布