mysql function error in syntax

Question

I am trying to write a function (MariaDB 10.2.9).

CREATE FUNCTION tesst (host VARCHAR(30)) RETURNS INT(4)
BEGIN
DECLARE hwid INT(4);

SELECT `id` INTO hwid FROM `hardware` WHERE `hostname` = host;

RETURN COALESCE(hwid, 'HWID not found');
END

Now I get the following error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 3

I do not know what the error is.

EDIT: It works with

delimiter //
CREATE FUNCTION tesst (host VARCHAR(30)) RETURNS int(4)
BEGIN
DECLARE hwid INT(4);

SELECT `id` INTO hwid FROM `hardware` WHERE `hostname` = host;

RETURN COALESCE(hwid, 'HWID not found');
END //
delimiter ;

And set:

Execute the following in the MySQL console:

SET GLOBAL log_bin_trust_function_creators = 1;

Add the following to the mysql.ini configuration file:

log_bin_trust_function_creators = 1

Did you change the delimiter before that? You need to. To avoid ending the function at the first ; — juergen d
– juergen d, Commented Oct 23, 2017 at 19:17
What do you mean? Sorry I do not know what delimiter is / how I use it. — Tobi
– Tobi, Commented Oct 23, 2017 at 19:19
Search "delimiter" in this documentation. Read the explanatory text below the code example you will find. — trincot
– trincot, Commented Oct 23, 2017 at 19:21

Tobi · Accepted Answer · 2017-10-23 20:15:18Z

0

So I did it. https://stackoverflow.com/a/26015334/8821276

Execute the following in the MySQL console:

SET GLOBAL log_bin_trust_function_creators = 1;

Add the following to the mysql.ini configuration file:

log_bin_trust_function_creators = 1

It works now, thank you!

answered Oct 23, 2017 at 20:15

Tobi

411 gold badge2 silver badges6 bronze badges

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

Collectives™ on Stack Overflow

mysql function error in syntax

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related