909422229_mysql创建函数

DELIMITER $$
 
USE `erp_ezweb`$$
 
DROP FUNCTION IF EXISTS `getProcessTime`$$
 
CREATE DEFINER=``@`` FUNCTION`getProcessTime`(infoid VARCHAR(100),userid VARCHAR(100)) RETURNS VARCHAR(250)CHARSET utf8
BEGIN
DECLARE name_temp1 VARCHAR(100)DEFAULT '';
DECLARE name_temp2 VARCHAR(100)DEFAULT '';
SELECT IFNULL(MAX(sdate),RDATE)INTO name_temp2 FROM g_pnodes WHERE info_id=infoid AND USER_ID=userid ANDSTATUS=-1;
   
RETURN name_temp2;
 
    END$$
 
DELIMITER ;
 
利用sql可以直接调用.

例如：
select  getProcessTime(info_id,userid);