Question

mysql的函数内为何定义变量报错？

CREATE DEFINER = CURRENT_USER FUNCTION `NewProc`(`p_presell_no_1` varchar)
RETURNS varchar(20)
BEGIN
DECLARE @ls_ret VARCHAR(20);
SET ls_ret='Error';
select nvl(presell_contract.presell_status, '0')
into @ls_ret
from presell_contract
where presell_contract.presell_no = p_presell_no_1;
RETURN @ls_ret;
END;

Answer 1

declare is_ret varchar(20);
--不能用@符