--------临时字段接受
update certificate_qxkc set gb_code_tm = gb_code;
------多次执行
update zltable set
property = (case
when SUBSTRING(property , 1, 1) not between '0' and '9' then SUBSTRING(property , 2)
ELSE property
end);
----获得第一个
update zltable set property = SUBSTRING(property , 1, 1)