mysql字符串长度不足位补0

这是我准备的一组数据，本文操作order_num字段

1.向左补0，LPAD(s1,len,s2)，在字符串 s1 的开始处填充字符串 s2，使字符串长度达到 len

SELECT *,lpad(order_num,4,0) as order_num格式化结果 FROM `stu`;

得出来的结果截图

2.向右补0，RPAD(s1,len,s2)，在字符串 s1 的结尾处添加字符串 s2，使字符串的长度达到 len

SELECT *,rpad(order_num,4,0) as order_num格式化结果 FROM `stu`;

3.字符串转化为数值型运算，这里转化为数值型 + 1

select *,cast(order_num as UNSIGNED) + 1 order_num运算后结果 from stu;

结合1,2点使用

select *,lpad(cast(order_num as UNSIGNED) + 1,4,0) order_num运算后结果 from stu;
select *,rpad(cast(order_num as UNSIGNED) + 1,4,0) order_num运算后结果 from stu;

4.实现自定义序列号

select @row_num:=@row_num+1,s.stu_name from stu s, (select @row_num:=0) t;