Syntax Error with MySql Workbench and IF Statement
Posted
by Hugo S.
on Stack Overflow
See other posts from Stack Overflow
or by Hugo S.
Published on 2010-04-14T16:07:18Z
Indexed on
2010/04/14
16:13 UTC
Read the original article
Hit count: 529
mysql
|mysqlworkbench
Hey guys, Im migrating from T-SQL to MySql syntax and don't know how to get over this syntax error given by Workbench 5.1.18:
-- --------------------------------------------------------------------------------
-- Routine DDL
-- --------------------------------------------------------------------------------
DELIMITER //
CREATE PROCEDURE `SysTicket`.`GetProductionLines` (aId INT, aActive INT, aResponsible VARCHAR(8000))
BEGIN
IF(aId > 0) THEN SELECT * FROM ProductionLine WHERE Id = @Id;
ELSE IF( aActive <> -1 AND aResponsible = '|$EMPTYARG$|') THEN SELECT * FROM ProductionLine;
ELSE IF(aResponsible = '|$EMPTYARG&|') THEN SELECT * FROM ProductionLine WHERE Active = aActive;
ELSE SELECT * FROM ProductionLine WHERE Active = aActive AND Responsible LIKE CONCAT('%', aResponsible, '%');
END IF;
END//
It says Syntax error near END (last line) ty in advance.
© Stack Overflow or respective owner