首页  >  文章  >  数据库  >  从Table1插记录到Table2,Field1不重复

从Table1插记录到Table2,Field1不重复

WBOY
WBOY原创
2016-06-07 15:54:461147浏览

insert into Table2(field1,field2,field3,field4,field5)(select field1,field2,field3,field4,field5 from Table1 where field1 not in (select field1 from Table2) and field1 is not null and field'')

insert into Table2(field1,field2,field3,field4,field5)(select field1,field2,field3,field4,field5 from Table1 where field1 not in (select field1 from Table2) and field1 is not null and field'')
声明:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn