User-defined function

This is an old revision of this page, as edited by Lankiveil (talk | contribs) at 12:10, 9 March 2006 (cat). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

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]