MySQL Create function returns error

Question

I am trying to create a function that returns rowcount. But it returns error again and again.

1064 - 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 '' at line 11

DELIMITER $$
CREATE FUNCTION func1(userid INT)
RETURNS INT
NOT DETERMINISTIC
BEGIN
  DECLARE var_name INT;
  SET var_name = 0;
  SELECT COUNT(*) INTO var_name
    FROM wps_bal
    WHERE u_id = userid;
  RETURN var_name;
END$$

Strange. Do you have code before that function when you execute? Remove it if so and execute this code only. — juergen d, Aug 15 '14 at 10:53

score 1 · Answer 1 · edited May 23 '17 at 12:34

1

Most probably your version of PHPMyAdmin does not support the DELIMITER statement which is not MySQL statement. Here you can find how to create the function in PHPMyAdmin: Store procedures in phpMyAdmin

edited May 23 '17 at 12:34

Community

1
1

answered Aug 15 '14 at 10:57

score 0 · Accepted Answer · edited May 23 '17 at 11:46

0

Yes. This was helpfull

I have created the solution:

DELIMITER $$
CREATE FUNCTION func1(userid INT)
RETURNS INT
NOT DETERMINISTIC
BEGIN
  DECLARE var_name INT;
  SET var_name = 0;
  SELECT COUNT(*) INTO var_name
    FROM wps_bal
    WHERE u_id = userid;
  RETURN var_name;
END$$
DELIMITER ;

edited May 23 '17 at 11:46

Community

1
1

answered Aug 15 '14 at 11:06

user174372

17
5

As per https://stackoverflow.com/help/self-answer, you can accept your own Answer after 48 hours. This will have the effect of removing your Question from the list of unanswered Questions. – toonice Apr 28 '17 at 16:27

MySQL Create function returns error

1064 - 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 '' at line 11

2 Answers2