DOC/3设计阶段/DB/02_function/currval.sql

DELIMITER $$


DROP FUNCTION IF EXISTS currval$$

CREATE FUNCTION currval(v_seq_name VARCHAR(50)) RETURNS VARCHAR(50) CHARSET utf8
BEGIN  
DECLARE SEQVALUE VARCHAR(50);  
	SET SEQVALUE = '';  
	SELECT current_val INTO SEQVALUE  
	FROM sequence   
	WHERE SEQ_NAME=v_seq_name;  
RETURN SEQVALUE;  
END$$

DELIMITER ;