|
010) from tb_stu;--返回1010所占空间的大小
8 常用的函数
select initcap(stu_name) from tb_stu;--首字符转换成大写
select stu_name,instr(stu_name,'s') from tb_stu;--查找s在stu_name中的位置 返回相应的值(0 n)
select length(stu_name) from tb_stu;--返回长度
select upper(stu_name) from tb_stu;--换大写
select lower(stu_name) from tb_stu;--换小写
select lpad(stu_name,11,'Hello') from tb_stu;--长度不够则在左边填充Hello 直到够11
|