update ext_testuser set ext_testuser.email = ext_smauser.email, |
ext_testuser.cellphone = ext_smauser.cellphone, |
ext_testuser.userid = ext_smauser.userid, |
ext_testuser.loginname = ext_smauser.loginname |
from ext_testuser left join ext_smauser on ext_smauser.idcard = ext_testuser.idcard |