syntax error in create function MySql

Question

I am getting a syntax error with this simple sample script in MySql 5.6.17 :

CREATE FUNCTION sampldb.fn_x(param VARCHAR(20))
RETURNS int
BEGIN
return 1;
END

What am i doing wrong? In Sql workbench, the error is shown in the last 2 lines.

It's just a generic syntax error. "You have an error in your SQL syntax. Check the manual...". Putting an ; at end makes no difference. — faizal
– faizal, Commented May 18, 2014 at 6:31

ashishmaurya · Accepted Answer · 2014-05-18 06:33:29Z

3

use DELIMITER

DELIMITER //
CREATE FUNCTION sampldb.fn_x(param VARCHAR(20))
RETURNS int
BEGIN
return 1;
END
//

answered May 18, 2014 at 6:33

ashishmaurya

1,19610 silver badges18 bronze badges

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

2 Comments

rekaszeru Over a year ago

And still use a semicolon after the END, some versions are sensitive about that.

faizal Over a year ago

DELIMITER did the trick! I mistakenly assumed that was required only when executing in the MySql monitor, and not in the workbench. I didn't need the ;

Collectives™ on Stack Overflow

syntax error in create function MySql

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related