This article has an unclear citation style. |
This article has not been added to any content categories. Please help out by adding categories to it so that it can be listed with similar articles, in addition to a stub category. |
User Defined Function, or UDF is an extension to a SQL database server (like MySQL) that can be compiled for use in a SQL query. For example, if it is necessary to obtain a random number for use as a primary key, and MySQL does not support that function, a new, external function could be written and compiled to accomplish this task. One sample of such query could be:
SELECT GETRANDOMKEY();
Essentially, this external function becomes part of the server itself.
For specific information pertaining to UDF's in MySQL, visit the MySQL website at [1]