56,937
社区成员




CREATE DEFINER = CURRENT_USER FUNCTION `getCategoryPath`(
catid INTEGER
)
RETURNS VARCHAR(255)
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
declare path varchar(255) ;
-- if catid=0 then
-- set path='';
-- else
-- declare catname varchar(255);
-- declare parentid INTEGER;
-- select cat_name INTO catname, parent_id into parentid
-- from 365mask_category where cat_id = catid;
-- set path=getCategoryPath(parentid)+'>'+catname;
-- end if;
RETURN path;
END ;
mysql> DELIMITER //
mysql> CREATE FUNCTION `getCategoryPath`(
-> catid INTEGER
-> )
-> RETURNS VARCHAR(255)
-> NOT DETERMINISTIC
-> CONTAINS SQL
-> SQL SECURITY DEFINER
-> COMMENT ''
-> BEGIN
-> declare path varchar(255) ;
-> -- if catid=0 then
-> -- set path='';
-> -- else
-> -- declare catname varchar(255);
-> -- declare parentid INTEGER;
-> -- select cat_name INTO catname, parent_id into par
entid
-> -- from 365mask_category where cat_id = catid;
-> -- set path=getCategoryPath(parentid)+'>'+catname;
-> -- end if;
-> RETURN path;
-> END //
Query OK, 0 rows affected (0.28 sec)
mysql>
mysql> DELIMITER ;
mysql>