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

Filed under:
|

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

Related posts about mysql

Related posts about mysqlworkbench