MySQL Function use provided variables throws error

Question

I want to create a function for calculating the distance between points.

The calculation is going as expected, but i receive an error here:

DROP FUNCTION IF EXISTS CalculateDistance;

CREATE FUNCTION CalculateDistance(breite double, laenge double) RETURNS INT READS SQL DATA

BEGIN

DECLARE breite DOUBLE;

SET @ibk_laenge = breite;

CREATE FUNCTION CalculateDistance(breite double, laenge double) RETURNS INT READS SQL DATA

BEGIN

DECLARE breite DOUBLE

MySQL meldet: Dokumentation 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 '' at line 5

What's wrong with that?

juergen d · Accepted Answer · 2017-04-24 18:49:49Z

1

You need to change the delimiter first:

delimiter //
CREATE FUNCTION CalculateDistance ...

END //
delimiter ;

Otherwise the function definition stops at the first ; which would make it incomplete.

edited Apr 24, 2017 at 18:49

answered Apr 24, 2017 at 18:20

juergen d

205k40 gold badges303 silver badges377 bronze badges

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

Collectives™ on Stack Overflow

MySQL Function use provided variables throws error

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