Problem with user defined function

Question

CREATE FUNCTION testing(id INT, dsc TEXT) RETURNS TEXT
BEGIN
DECLARE ntxt TEXT;
SET ntxt = dsc;
RETURNS ntxt;
END;

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 'TEXT' at line 3

What i miss here ?

Álvaro González · Accepted Answer · 2010-11-23 15:37:46Z

1

You forgot to change the delimiter
RETURN has an extra S

This does work:

DELIMITER //

CREATE FUNCTION testing(id INT, dsc TEXT) RETURNS TEXT
BEGIN
    DECLARE ntxt TEXT;
    SET ntxt = dsc;
    RETURN ntxt;
END//

answered Nov 23, 2010 at 15:37

Álvaro González

147k45 gold badges282 silver badges378 bronze badges

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

1 Comment

Nick Over a year ago

DELIMITER was the problem. Thanks

a1ex07 · Accepted Answer · 2010-11-23 15:32:21Z

0

You probably forgot to add DELIMITER $$ in the very beginning of your script (Standard delimiter is ;, and it's also used in procedures/functions). For example,

 DELIMITER $$
 [CREATE FUNCTION ...... ]
 $$
 DELIMITER ;

answered Nov 23, 2010 at 15:32

a1ex07

37.4k12 gold badges93 silver badges103 bronze badges

3 Comments

Jon Black Over a year ago

why are coders obsessed with the $$ when a single non ; will do - like a # ?

Álvaro González Over a year ago

@f00, I guess you feel better when the alternative delimiter is not likely to appear anywhere else.

a1ex07 Over a year ago

+1. Just for example :) Surely, it can be anything. Personally I prefer //. But it seems $$ to be more "common"

Collectives™ on Stack Overflow

Problem with user defined function

2 Answers 2

1 Comment

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Related