我忘记了放分隔符指令,一些分号,并使用tsl语法,如[select variable = field],在mysql中无效。
当你使用tsl语法时,Mysql错误是[不允许从函数返回结果集],并没有多大帮助。
@AndreKR把所有的都指向我,谢谢。我使用的是mysql工作台5.2.30 CE。功函数变为:
delimiter //
CREATE FUNCTION nextval (seq_name varchar(100))
RETURNS bigint(20)
READS SQL DATA
NOT DETERMINISTIC
BEGIN
DECLARE workval bigint(20);
SELECT count(1) into workval
FROM tip_sequence
WHERE sequencename = seq_name;
IF workval <> 1 THEN
DELETE
FROM tip_sequence
WHERE sequencename = seq_name;
INSERT
INTO tip_sequence (sequencename, sequenceval, sequencestep)
VALUES (seq_name, 1, 1);
END IF;
SELECT sequenceval into workval
FROM tip_sequence
WHERE sequencename = seq_name;
UPDATE tip_sequence
SET sequenceval = sequenceval + sequencestep
WHERE sequencename = seq_name;
RETURN workval;
END//
delimiter ;
我不认为SELECT workval = count(1) FROM ...
语法是有效的。我想你的意思是:SELECT count(1) INTO workval FROM ...