CREATE DEFINER=`root`@`%` 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 sys_sequence WHERE NAME = seq_name;
RETURN VALUE;
END
workbench执行的时候,需要修改命令分隔符为 “$$”,防止执行中函数中的 “;” 符截断函数
delimiter $$
CREATE DEFINER=`root`@`%` 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 sys_sequence WHERE NAME = seq_name;
RETURN VALUE;
END
$$
delimiter ;