第二步

银行档案

update bd_bankdoc set bankdoccode='04N'|| bankdoccode , pk_banktype='0001ZZ1000000001OCUD' where pk_banktype<>'0001ZZ1000000001OCUD'   and bankdocname like '%建%'    and   bankdocname not like '工%'    and   bankdocname not like '%工商%'      and bankdocname not like '%农%'    and bankdocname not like '中行%'    and bankdocname not like '中国银行%'      and bankdocname not like '%民生银行%'       and bankdocname not like '%招商%'         and bankdocname not like '%南昌银行%'           and bankdocname not like '交%'            and bankdocname not like '保定银行%'            and bankdocname not like '%建工%'           and bankdocname not like '%邮政%'

第一步

客商银行账户

提醒：如果上面是第一步导致上面的更新完，下面查不到东西

update bd_bankaccbas set pk_bankdoc='0001ZZ1000000001OCUD'  where pk_bankdoc in(select pk_bankdoc from bd_bankdoc   where pk_banktype<>'0001ZZ1000000001OCUD'   and bankdocname like '%建%'    and   bankdocname not like '工%'    and   bankdocname not like '%工商%'      and bankdocname not like '%农%'    and bankdocname not like '中行%'    and bankdocname not like '中国银行%'      and bankdocname not like '%民生银行%'       and bankdocname not like '%招商%'         and bankdocname not like '%南昌银行%'           and bankdocname not like '交%'            and bankdocname not like '保定银行%'            and bankdocname not like '%建工%'           and bankdocname not like '%邮政%' )

 不敢更新，貌似有问题，更新之后开户以后空了