SELECT customer_code ,trim(LEADING '0' from customer_code) from ii_customer_en
BOTH
:表示要从字符串中删除的左右前缀。LEADING
:表示只删除前导前缀。TRAILING
:表示仅删除尾随前缀。Str_to_remove
:表示要从字符串中删除的字符串
#去除前缀0
update ii_customer_zh set customer_code = TRIM(LEADING '0' FROM customer_code)