SQL語句:
復(fù)制代碼 代碼如下:
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查詢?nèi)コ貜?fù)記錄
- sqlserver 用戶權(quán)限管理,LINQ去除它的重復(fù)菜單項
- sqlserver利用存儲過程去除重復(fù)行的sql語句
- mysql SELECT語句去除某個字段的重復(fù)信息
- Mysql刪除重復(fù)的數(shù)據(jù) Mysql數(shù)據(jù)去重復(fù)
- MySQL中distinct語句去查詢重復(fù)記錄及相關(guān)的性能討論
- SQL分組排序去重復(fù)的小實例
- oracle sql 去重復(fù)記錄不用distinct如何實現(xiàn)
- SQL語句去掉重復(fù)記錄,獲取重復(fù)記錄
- SQL去除重復(fù)記錄(七種)