这是我的代码:
DELIMITER $$
CREATE PROCEDURE `Get_Next_Processing_Video`
(
OUT out_IDVideo INT ,
OUT out_YoutubeIDVideo VARCHAR(15)
)
BEGIN
SELECT NP.IDVideo INTO out_IDVideo
FROM next_processing AS NP
Limit 1
UPDATE TABLE Video AS V
SET V.SchedulingFlag = TRUE
WHERE IDVideo = out_IDVideo
END我不明白错误在哪里??
发布于 2013-01-29 22:13:17
错误:
你没有终止你的第一个关键字statement
TABLE后你的UPDATE关键字。修复代码:
DELIMITER $$
CREATE PROCEDURE `Get_Next_Processing_Video`
(
OUT out_IDVideo INT ,
OUT out_YoutubeIDVideo VARCHAR(15)
)
BEGIN
SELECT NP.IDVideo INTO out_IDVideo
FROM next_processing AS NP
Limit 1;
UPDATE Video AS V
SET V.SchedulingFlag = TRUE
WHERE IDVideo = out_IDVideo;
END $$
DELIMITER ;或者,您可以使用SET为变量赋值。
SET out_IDVideo = (SELECT NP.IDVideo
FROM next_processing AS NP
Limit 1); https://stackoverflow.com/questions/14584901
复制相似问题