SQL语句:
复制代码 代码如下:
INSERT INTO Whir_ezMall_Full_c..Whir_Member(MemberID, LevelID, Account, MemberPWD, Email, Integral, MemberName, MemberStatus, Sex, Birthday, Area, Adress, ZipCode, Tel, Mobile, SaveQuestion, SaveAnswer, CreateData, LastLoginData, ImgUrl, LimitIntegral, IntegralBeginTime, IntegralEndTime, memberType, BankType, BankRegion, BankAddress, BankAccount, BankName, IsQQ)
SELECT MemberID, LevelID, Account, MemberPWD, Email, Integral, MemberName, MemberStatus, Sex, Birthday, Area, Adress, ZipCode, Tel, Mobile, SaveQuestion, SaveAnswer, CreateData, LastLoginData, ImgUrl, LimitIntegral, IntegralBeginTime, IntegralEndTime, memberType, BankType, BankRegion, BankAddress, BankAccount, BankName, IsQQ FROM Whir_ezMall_Full..Whir_Member
WHERE Whir_ezMall_Full..Whir_Member.MemberID NOT IN (SELECT MemberID FROM Whir_Member)
您可能感兴趣的文章:- 解析mysql中:单表distinct、多表group by查询去除重复记录
- sqlserver 用户权限管理,LINQ去除它的重复菜单项
- sqlserver利用存储过程去除重复行的sql语句
- mysql SELECT语句去除某个字段的重复信息
- Mysql删除重复的数据 Mysql数据去重复
- MySQL中distinct语句去查询重复记录及相关的性能讨论
- SQL分组排序去重复的小实例
- oracle sql 去重复记录不用distinct如何实现
- SQL语句去掉重复记录,获取重复记录
- SQL去除重复记录(七种)