dcsimg
LinkedIn
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Creating User Defined Functions

Language: SQL, Expertise: Intermediate - Learn more about how MySQL allows you to create functions that can be used to repeatedly perform a certain task.


advertisement

There are many instances in which you might repeatedly use some functionality. It would be handy if you were allowed to create a function that could be used as, and when, needed.

MySQL allows you to create FUNCTIONS that can be used this way.

Syntax:

CREATE FUNCTION (argument list) 
RETURNS  DETERMINISTIC 
RETURN ();

I have chosen the method name as SUMSUM, since SUM is already available as a default function.

Now, when you use this function as below:

SELECT SUMSUM (5,6);

It results in the following:

+--------------+
| SUMSUM (5,6) |
+--------------+
|           11 |
+--------------+

In case you think that the Function created by you will be of no use henceforth, you can safely delete it with the following command.

DROP FUNCTION SUMSUM;


   
Email AuthorEmail Author
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date