MySQL. Procedure, wrong syntax

Question

I am trying to learn how procedures work and I get an error and I don't know why.

DELIMITER //
CREATE PROCEDURE producer
(IN marcaMasinii VARCHAR(20))
SELECT DISTINCT producator, AVG(pret) AS medie 
FROM vehicul v
JOIN proprietate p
ON v.id_vehicul = p.nr_vehicul
WHERE producator = marcaMasinii;
END //
DELIMITER ;

CALL producer("Dacia");

I have this procedure and I get an error on the line where "END //" is. The error sounds like this:

"Syntax error, unexpected END, expecting $END."

If I add the "BEGIN", the code looks like:

DELIMITER //
CREATE PROCEDURE producer
(IN marcaMasinii VARCHAR(20))
BEGIN
SELECT DISTINCT producator, AVG(pret) AS medie 
FROM vehicul v
JOIN proprietate p
ON v.id_vehicul = p.nr_vehicul
WHERE producator = marcaMasinii;
END //
DELIMITER ;

CALL producer("Dacia");

The error looks like this:

"Syntax error, unexpected CREATE, expecting END_OF_INPUT or ;"

What's wrong with the syntax? Can someone explain?

You are missing BEGIN hence END is unexpected

Abhik Chakraborty
– Abhik Chakraborty

2014-05-29 14:44:00 +00:00
Commented May 29, 2014 at 14:44 — Abhik Chakraborty
– Abhik Chakraborty, Commented May 29, 2014 at 14:44

zhongxiao37 · Accepted Answer · 2014-05-29 14:52:12Z

1

Put the BEGIN before SELECT. You need to read http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html first.

answered May 29, 2014 at 14:52

zhongxiao37

9878 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL. Procedure, wrong syntax

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related