三个存储函数:
----
create function test.morestart(n int)
returns text
begin
declare i int default 0;
declare s text default '';
myloop:loop set i=i+1;
set s = concat(s,'*');
if i>n then leave myloop;
end if;
end loop myloop;
return s;
end$
---
create function test.cutString(s varchar(255),n int)
returns varchar(255)
begin
if (isnull(s)) then return '';
elseif char_length(s)<n then return s;
elseif char_length(s)=n then return '=';
else return concat(left(s,n),'...');
end if;
end$
---
create function test.getDate(gdate datetime)
returns varchar(255)
begin
declare x varchar(255) default '';
set x = date_format(gdate,'%Y%m%d%h%i%s');
return x;
end$
转载于:https://my.oschina.net/fangfeiAI/blog/309763