sql给整数补零

update hs_user.clientorder a set a.stockcode = lpad(a.stockcode,6,'0') where a.market = 'SZ'

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/timlong/p/6014548.html