delimiter $$ create function fun1(numberInPut bigint(20)) returns varchar(40) DETERMINISTIC begin declare sTemp varchar(20); declare sResult varchar(40) default ''; declare size int; set sTemp = cast(numberInPut as char); set size = length(sTemp); set @i = 1; while @i <= size do set @c = substring(sTemp,@i,1); set sResult = concat(sResult, '/', @c); set @i = @i+1; end while; return concat(sResult,'/'); end $$
create function fun1(numberInPut bigint(20)) returns varchar(40)
DETERMINISTIC
begin
declare sTemp varchar(20);
declare sResult varchar(40) default '';
declare size int;
set sTemp = cast(numberInPut as char);
set size = length(sTemp);
set @i = 1;
while @i <= size do
set @c = substring(sTemp,@i,1);
set sResult = concat(sResult, '/', @c);
set @i = @i+1;
end while;
return concat(sResult,'/');
end $$