DELIMITER $$
USE `test`$$
DROP FUNCTION IF EXISTS `currval`$$
CREATE DEFINER=`root`@`localhost` FUNCTION `currval`(seq_name VARCHAR(50)) RETURNS INT(11)
READS SQL DATA
DETERMINISTIC
BEGIN
DECLARE VALUE INTEGER;
SET VALUE = 0;
SELECT current_value INTO VALUE FROM sequence WHERE NAME = seq_name;
RETURN VALUE;
END$$
DELIMITER ;
USE `test`$$
DROP FUNCTION IF EXISTS `currval`$$
CREATE DEFINER=`root`@`localhost` FUNCTION `currval`(seq_name VARCHAR(50)) RETURNS INT(11)
READS SQL DATA
DETERMINISTIC
BEGIN
DECLARE VALUE INTEGER;
SET VALUE = 0;
SELECT current_value INTO VALUE FROM sequence WHERE NAME = seq_name;
RETURN VALUE;
END$$
DELIMITER ;
扫一扫
367
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
