Migrate data from one table in one database to a table of the same structure in another database

Migrate data from the whir_member table in the whir_ezmall_full database to the whir_member table in the whir_ezmall_full_c database. If an existing ID record exists, it is not inserted.

Insert into whir_ezmall_full_c .. whir_member (memberid, levelid, account, memberpwd, email, integral, membername, memberstatus, sex, birthday, area, adress, zipcode, tel, mobile, savequestion, region, 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)