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去除重復記錄（七種）
