MySQL where clause in store procedure 2

[robert201]

Hello,

I have the following stored procedure:

But I get the following error message on the where clause. The staffID is an input.
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE StaffID = _StaffID;

Many thanks for any assistance.

Steve

CREATE PROCEDURE `erestaurant`.`GetOrdersSelByStaffID`(IN _StaffID INTEGER) 
    /*LANGUAGE SQL
    | [NOT] DETERMINISTIC
    | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
    | SQL SECURITY { DEFINER | INVOKER }
    | COMMENT 'string'*/
    BEGIN
	
	SELECT * FROM Orders;
	WHERE StaffID = _StaffID;
    END$$

DELIMITER ;

 

[towerbase]

Should there be a semi colon after Orders ?

I'm only guessing because I don't know how to write Stored Procedures.


Andrew
Hampshire, UK

 

[r937]

the SQL inside stored procedures is the same SQL as in ordinary queries

the semicolon terminates the SELECT

the WHERE (incorrectly) starts a new statement



r937.com | rudy.ca