mysql 表B字段替换表A字段

update crm_customer set crm_customer.email = (select crm_customer_tmp.email from crm_customer_tmp where crm_customer.code = crm_customer_tmp.code) where id > 0;