insert into tablename select where not in (select)的示例

[mysql] 2024-04-25 圈点529

摘要:insert into tablename select where not in (select)的示例

insert into tao_mulu(muluming,mulumdf)

select spmulu,mulumdf from tao_sp

where mulumdf not in (select mulumdf from tao_mulu)
group by spmulu

insert  select  

感谢反馈,已提交成功,审核后即会显示