SYNTAX NEAR LINE 1 FOR STORED PROCEDURE

[theogary]

i AM TRYING TO RUN THIS STORED PROCEDURE IN MYSQL CONTROL CENTER i GET A ERROR ON LINE 1

i AM A NEWBEE BUT i GOT MY SYNTAX FROM MYSQL WEB SITE. WHAT IS MY SYNTAX ERROR?

CREATE PROCEDURE TEST()
BEGIN
DECLARE done INT DEFAULT 0
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1
DECLARE cur1 CURSOR FOR SELECT home,visitor,league,home_score,visitor_score,home_forfiet,visitor_forfiet
FROM schedule_table
DECLARE hteam CHAR(20)
DECLARE vteam CHAR(20)
DECLARE league CHAR(40)
DECLARE Vforfiet CHAR(1)
DECLARE hforfiet CHAR(1)
DECLARE hrun int
DECLARE Vrun INT

OPEN cur1

REPEAT
FETCH cur1 INTO hteam ,vteam ,league ,hrun ,vrun ,hforfiet ,vforfiet

IF NOT done THEN

IF HFORFIET = 'Y' OR VFORFIET = 'Y' THEN
IF HFORFIET = 'Y'THEN
INSERT INTO STANDING_DETAIL VTEAM,LEAGUE,'W'
INSERT INTO STANDING_DETAIL HTEAM,LEAGUE,'L'
END IF
IF vFORFIET = 'Y'THEN
INSERT INTO STANDING_DETAIL HTEAM,LEAGUE,'W'
INSERT INTO STANDING_DETAIL vTEAM,LEAGUE,'L'
END IF
END IF


IF HRUN > VRUN THEN
INSERT INTO STANDING_DETAIL HTEAM,LEAGUE,'W'
INSERT INTO STANDING_DETAIL VTEAM,LEAGUE,'L'
END IF
IF VRUN > HRUN THEN
INSERT INTO STANDING_DETAIL VTEAM,LEAGUE,'W'
INSERT INTO STANDING_DETAIL HTEAM,LEAGUE,'L'
END IF

IF HRUN > 0 AND VRUN > 0 AND VRUN = HRUN THEN
INSERT INTO STANDING_DETAIL HTEAM,LEAGUE,'T'
INSERT INTO STANDING_DETAIL VTEAM,LEAGUE,'T'
END IF


UNTIL done END REPEAT

CLOSE cur1
END

 

[sleipnir214]

What version of MySQL are you running? Stored procedures are not supported in versions less than 5.0 -- which is classified as alpha-level software.

Want the best answers? Ask the best questions!

TANSTAAFL!!