mysql 像Oracle一样 解决方案
DROP FUNCTION IF EXISTS currval;?
DELIMITER $?
CREATE FUNCTION currval (seq_name VARCHAR(50) CHARACTER SET utf8 )?
RETURNS INTEGER?
CONTAINS SQL?
BEGIN?
? DECLARE value INTEGER;?
? SET value = 0;?
? SELECT current_value INTO value?
? FROM sequence?
? WHERE name = seq_name COLLATE utf8_general_ci;?
? RETURN value;?
END$?
DELIMITER ;?
DROP FUNCTION IF EXISTS setval;?
DELIMITER $?
CREATE FUNCTION setval (seq_name VARCHAR(50) CHARACTER SET utf8? , value INTEGER)?
RETURNS INTEGER?
CONTAINS SQL?
BEGIN?
?? UPDATE sequence?
?? SET????????? current_value = value?
?? WHERE name = seq_name COLLATE utf8_general_ci;?
?? RETURN currval(seq_name);?
END$?
DELIMITER ;?
DROP FUNCTION IF EXISTS nextval;?
DELIMITER $?
CREATE FUNCTION nextval (seq_name VARCHAR(50) CHARACTER SET utf8 )?
RETURNS INTEGER?
CONTAINS SQL?
BEGIN?
?? UPDATE sequence?
?? SET????????? current_value = current_value + increment?
?? WHERE name = seq_name COLLATE utf8_general_ci;?
?? RETURN currval(seq_name);?
END$?
DELIMITER ;
