当前位置：首页 -> AI编程基础 -> 数据库编程

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

2014-11-24 14:03:31 · 作者: · 浏览: 0
标签: Table1 记录 Table2 Field1 重复
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<>'')