mysql 字段左右补0 右补0:select RPAD(id,8,‘0’) as num from tmp;左补0:select LPAD(id,8,‘0’) as num from tmp; 参数 :id:为字段名称8:为补全的位数0:代表补的参数0