1.备份表
create table cust_info_v as select * from cust_info;
2.查看截取后的字段值
select SUBSTR(cb_id,3) from cust_info_v where cb_id like '01-%';
3.更新数据表
UPDATE cust_info SET cb_id = REPLACE(cb_id, cb_id, SUBSTR(cb_id,4)) where cb_id like '01-%';
drop table cust_info_v;