12.2 Adding New Functions to MySQL

There are two ways to add new functions to MySQL:

• You can add the function through the user-definable function (UDF) interface. User-definable functions are added and removed dynamically using the CREATE FUNCTION and DROP FUNCTION statements. See section 12.2.1 CREATE FUNCTION/DROP FUNCTION Syntax.
• You can add the function as a native (built in) MySQL function. Native functions are compiled into the mysqld server and become available on a permanent basis.

Each method has advantages and disadvantages:

• If you write a user-definable function, you must install the object file in addition to the server itself. If you compile your function into the server, you don't need to do that.
• You can add UDFs to a binary MySQL distribution. Native functions require you to modify a source distribution.
• If you upgrade your MySQL distribution, you can continue to use your previously installed UDFs. For native functions, you must repeat your modifications each time you upgrade.

Whichever method you use to add new functions, they may be used just like native functions such as ABS() or SOUNDEX().

Subsections

• 12.2.1 CREATE FUNCTION/DROP FUNCTION Syntax
• 12.2.2 Adding a New User-definable Function
• 12.2.2.1 UDF Calling Sequences for simple functions
• 12.2.2.2 UDF Calling Sequences for aggregate functions
• 12.2.2.3 Argument Processing
• 12.2.2.4 Return Values and Error Handling
• 12.2.2.5 Compiling and Installing User-definable Functions
• 12.2.3 Adding a New Native Function

User Comments

So, what does 'SONAME' do?

In Windows SONAME as a DLL files and In *Nix as a SO files.

Add your own comment.