mysql 如何创建这样一个函数
咖啡加糖_ 2014-02-27 11:08:50 是oracle中的函数要迁移到mysql中,
oracle中函数如下
CREATE OR REPLACE FUNCTION "GET_ROMA_NUM_PY"(p_Index NUMBER)
RETURN NUMBER IS
v_rom_num_list TROMA_NUM_LIST := TROMA_NUM_LIST(
'1','2','3','4','5','6','7','8','9','10','','','','','','',
'1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20',
'1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20',
'1','2','3','4','5','6','7','8','9','10','','',
'1','2','3','4','5','6','7','8','9','10','','',
'1','2','3','4','5','6','7','8','9','10','11','12','',''
);
BEGIN
IF (p_Index>0) AND (p_Index<95) THEN
RETURN v_rom_num_list(p_Index);
ELSE
RETURN '';
END IF;
end get_roma_num_py;
大概意思就是 定义一个集合,然后根据输入的参数索引输出一个值
怎么改成mysql里的,头疼