mysql 中将某个栏位为1位的前面补0变成3位 UPDATE qms_inspection_template SET process = LPAD( process, 3, '0' ) where LENGTH(process) = 1