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