How to create a MySQL create function?

Question

I want to create a simple function like below to do an easy task:

DELIMITER $$
CREATE FUNCTION f(key TEXT, str TEXT) RETURNS INT
BEGIN
    IF LOCATE(key, str) > 0 THEN
        RETURN 1;
    ELSE
        RETURN 0;
    END IF;
END $$
DELIMITER ;

But I got an error:

ERROR 1064 (42000): 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 'key T
EXT, str TEXT) RETURNS INT
BEGIN
    IF LOCATE(key, str) > 0 THEN
        R' at line 1

What's the problem?

What's the error? Please think about how people might go about diagnosing this problem before submitting your question. — tadman
– tadman, Commented Jan 28, 2013 at 18:38

Jon · Accepted Answer · 2013-01-28 18:41:04Z

3

The function has a syntax error because key is a reserved word in MySql. Solution: rename the parameter or put key inside backticks like this:

CREATE FUNCTION f(`key` TEXT, str TEXT) RETURNS INT

answered Jan 28, 2013 at 18:41

Jon

439k85 gold badges756 silver badges820 bronze badges

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

Comments

Gustek · Accepted Answer · 2013-01-28 18:40:44Z

1

key is a keyword in mysql, put it between ` or use different name.

answered Jan 28, 2013 at 18:40

Gustek

3,7603 gold badges25 silver badges39 bronze badges

Collectives™ on Stack Overflow

How to create a MySQL create function?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related