Can't get suored procedures to work

[mdsmith1]

Here is a stored procedure right out of the book.

DELIMITER //

CREATE PROCEDURE GetInvoices()
BEGIN
	SELECT ITEM, PRICE  FROM Invoices01;
END //

DELIMITER ;

I am attaching a screen shot of the error message.

Why isn't this working

Mike

...

[joeBumbaca]

Hey @mdsmith1! You should be able to omit the DELIMITER statements in your Retool query. This works for both single and multi statement procedures.

Single Statement Procedure:

Response:

Multi Statement Procedure:

Response:

Let me know if you have any other questions!

[mdsmith1]

John:

Thank you for this.

Actually my biggest problem with Stored Procedures is its difficulties in handling IF Statements and DO WHILE Loops.

In any case I will retain this tip for the next time around.

Mike