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

潘先生 日期:2017-07-28

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,

属分类: mysql

0 0
网圵:http://127.0.0.13/Article/show/i/484.html
留言:
登录  注册
三思而后言,谢谢。