Error in MySQL function with parameters

Question

I have MySQL function with 2 parameters namely user_id and post_id

Here's my function:

CREATE FUNCTION isliked(pid INT, uid INT)
RETURN TABLE
AS
RETURN (EXISTS (SELECT 1 FROM likedata ld WHERE post_id = pid AND user_id = uid
       )) as is_liked
END

I tried to call it with below query:

SELECT posts.id, posts.title, isliked(111,123)
FROM posts

It returns the following error:

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 'RETURN TABLE
AS
RETURN (EXISTS (SELECT 1 FROM likedata ld WHERE post_id = pid AN' at line 2

It should be return results like this http://sqlfiddle.com/#!9/91040/5 I'm new to sql, any help will be great, thanks in advance

your function have syntax problem. go the office mysql site and find the syntax of what's actual does syntax and make the appropriate changes — Ankit Agrawal
– Ankit Agrawal, Commented May 28, 2018 at 5:35
You probably want to return a Boolean/bit rather than a table. You only need one value and it looks like you want to use it in the select clause. — Horia Coman
– Horia Coman, Commented May 28, 2018 at 5:43
What is the expected output? What do you want isliked function to return? — dWinder
– dWinder, Commented May 28, 2018 at 6:24

dWinder · Accepted Answer · 2018-05-28 06:54:58Z

1

If you want the function to return Boolean value use:

CREATE FUNCTION isliked(pid INT, uid INT)
RETURNS BIT
   RETURN ( EXISTS ( SELECT 1 FROM likedata ld WHERE post_id = pid AND user_id = uid ) )

edited May 28, 2018 at 6:54

answered May 28, 2018 at 6:35

dWinder

11.7k3 gold badges27 silver badges40 bronze badges

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

Collectives™ on Stack Overflow

Error in MySQL function with parameters

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