2022-11-23_update_customer.sql

-- 设置客户为开发客户
update jiedao.ecw_customer new
    inner join jiedao_old_20221123.ecw_customer old on new.number = old.number
    set new.resource_type = 1
where old.resource = 0;


-- 设置客户为公司客户
update jiedao.ecw_customer new
    inner join jiedao_old_20221123.ecw_customer old on new.number = old.number
    set new.resource_type = 2
where old.resource = 1;