delimiter $$
create function getSpaceText(inputString varchar(100)) returns varchar(200)
begin
declare spaceString varchar(200);
declare inputLength int;
set inputLength = length(inputString);
set spaceString = space(inputLength*2);
set @i = 1;
while (@i <= inputLength) do
set @v = substring(inputString,@i,1);
set spaceString = insert(spaceString,@i*2-1,1,@v);
set @i = @i+1;
end while;
return spaceString;
end $$
select getSpaceText('ABCDEFG');
create function getSpaceText(inputString varchar(100)) returns varchar(200)
begin
declare spaceString varchar(200);
declare inputLength int;
set inputLength = length(inputString);
set spaceString = space(inputLength*2);
set @i = 1;
while (@i <= inputLength) do
set @v = substring(inputString,@i,1);
set spaceString = insert(spaceString,@i*2-1,1,@v);
set @i = @i+1;
end while;
return spaceString;
end $$
select getSpaceText('ABCDEFG');
INSERT INTO nums VALUES(1),(2),(3),(4),(5),(6),(7),(8),(9),(10)
SET @a='abcdefg';
SELECT GROUP_CONCAT(col SEPARATOR ' ') AS col FROM (SELECT SUBSTR(@a,id,1) col FROM nums) t;
/*
col
------------------
a b c d e f g */