Function in mysql

Question

I am have created function in mysql.

This is code of my function

 DROP FUNCTION `star`//

CREATE DEFINER=`root`@`localhost` FUNCTION `star`(
num INT

) RETURNS int(11)
DETERMINISTIC
 BEGIN

                IF(num>=0 && num<20)
                THEN
                RETURN 1;
                ELSEIF(num>=20 && num<40)
                THEN
                RETURN 2;
                ELSEIF(num>=40 && num<60)
                THEN
                RETURN 3;
                ELSEIF(num>=60 && num<80)
                THEN
                RETURN 4;
                ELSEIF(num>=80 && num<=100)
                THEN
                RETURN 5;
                END IF;
    END

I have forgotten how did i made this function in my database. Now i want to create same function into another database.

For this i just copy above code and paste that in sql. and press Go. But it creates error. Please tell me what mistake i have done.

MySQL said: #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 '// CREATE DEFINER=root@localhost FUNCTION star( num int )' at line 1 — Pushpendra Kuntal
– Pushpendra Kuntal, Commented Feb 14, 2012 at 10:02
When i remove my first line of code then i creates problem in if condition. I dont know whats happening here. Even i created same procedure in one database then why this is creating problem into another database. — Pushpendra Kuntal
– Pushpendra Kuntal, Commented Feb 14, 2012 at 10:03

gbn · Accepted Answer · 2012-02-14 10:01:36Z

1

You need a DELIMITER // statement at the top...

answered Feb 14, 2012 at 10:01

gbn

435k84 gold badges602 silver badges690 bronze badges

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

Collectives™ on Stack Overflow

Function in mysql

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