帮我看看mysql存储函数有什么错误
delimiter //
CREATE FUNCTION getpercent(dec1 char(20),dec2 char(20))
returns char(50)
begin
DECLARE Result char(50);
SET Result = '';
if ifnull(dec1,0)=0 or ifnull(dec2,0)=0 then
Result='0';
elseif dec1>=dec2 then
Result='100';
else
Result = round(dec1 / dec2 * 100, 2);
if substr(Result,0,1)='.' then
Result =concat('0',Result);
end if;
end if;
Result =concat(Result,'%');
return (Result);
end //
[解决办法]
mysql> delimiter //mysql> CREATE FUNCTION getpercent(dec1 int,dec2 int) -> returns char(50) -> begin -> DECLARE Result char(50); -> SET Result = ''; -> if ifnull(dec1,0)=0 or ifnull(dec2,0)=0 -> then return 0; -> elseif dec1>=dec2 -> then return 100; -> else -> set Result = round(dec1 / dec2 * 100, 2); -> if substr(Result,0,1)='.' -> then return round(dec1 / dec2 * 100, 2); -> else -> return concat(Result,'%'); -> end if; -> end if; -> end //Query OK, 0 rows affected (0.00 sec)mysql> delimiter ;mysql> select getpercent(NULL,0);+--------------------+| getpercent(NULL,0) |+--------------------+| 0 |+--------------------+1 row in set (0.00 sec)mysql> select getpercent(0,0);+-----------------+| getpercent(0,0) |+-----------------+| 0 |+-----------------+1 row in set (0.00 sec)mysql> select getpercent(1,2);+-----------------+| getpercent(1,2) |+-----------------+| 50.00% |+-----------------+1 row in set (0.00 sec)mysql> select getpercent(2,1);+-----------------+| getpercent(2,1) |+-----------------+| 100 |+-----------------+1 row in set (0.02 sec)
