mysql function syntax no query specified

Question

the function is this:

delimiter |

create function average() returns int
    begin 
        declare AB int;
        set AB= avg(attribute1) from tablename where attribute2='AMG' ;
        return AB; 
    end; 
|

ERROR    No query specified

What i do wrong?

Saharsh Shah · Accepted Answer · 2014-01-02 12:14:15Z

1

Try this:

DELIMITER | 

    CREATE FUNCTION   average()
    RETURNS INT
    BEGIN DECLARE AB INT;
    SELECT AVG(attribute1) INTO AB FROM tablename WHERE attribute2='AMG' ;
    RETURN AB; END; |

answered Jan 2, 2014 at 12:14

Saharsh Shah

29.1k9 gold badges53 silver badges85 bronze badges

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

2 Comments

user3153534 Over a year ago

You are awesome. It works!!! Thanks. But what i did wrong? Is it wrong to use 'SET' in a function?

Saharsh Shah Over a year ago

@user3153534 You're most welcome... You have syntax error in your query. If you got desired output and an active member of stackoverflow try to accept and upvote the answer. How to use stackoverflow take a tour of that on this link stackoverflow.com/tour. It will describe how to accept and upvote the answer.

Collectives™ on Stack Overflow

mysql function syntax no query specified

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related