Syntax Error in MySQL Procedure

Question

Navigation

#1 by (0 votes)

0

I have the following Stored Procedure. When you run it, the syntax error 1064 is not returned as in the image below.

What am I missing?

mysql stored-procedures syntax-error

asked by anonymous 18.03.2015 / 17:11

1 answer

Redirect URL to a file with htaccess Add a fixed word to a friendly URL

score 0 · Answer 1

Hello! Try changing the end of the mysql statement

As for example:

DELIMITER $$ CREATE PROCEDURE nome_procedimento () BEGIN /*CORPO DO PROCEDIMENTO*/ END $$ DELIMITER ;

In this part:

END $$ DELIMITER ;

:)