Declare variable syntax invalid in MySQL?

Question

I'm trying to run a simple code that had already run on another machine and worked perfectly, now that I try to run it on my machine I get the syntax error.

I run it in Workbench Version 8.0

delimiter $$
create function funcion_mul(P_NUM2 INT)
returns INT
begin
    DECLARE declare valor_final INT default 0;
    RETURN valor_final;
END;
$$
delimiter ;

"DECLARE" is no valid at this position for this server version, expecting :

¿Qué es lo que está mal?

Thanks

You have a typo: DECLARE declare

Barmar
– Barmar

2019-08-19 23:59:04 +00:00
Commented Aug 19, 2019 at 23:59 — Barmar
– Barmar, Commented Aug 19, 2019 at 23:59

azbarcea · Accepted Answer · 2019-08-20 00:09:45Z

1

What about removing the declare duplication ?

delimiter $$
CREATE FUNCTION funcion_mul(P_NUM2 INT)
RETURNS INT
BEGIN
    DECLARE valor_final INT default 0;
    RETURN valor_final;
END;
$$
delimiter;

answered Aug 20, 2019 at 0:09

azbarcea

3,7172 gold badges22 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

Declare variable syntax invalid in MySQL?

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