Writing Your Own UDFs

By now you should have gathered that UDFs rely on there being a C or C++ program to define them. Although it is straightforward to add the sample UDFs to your MySQL server, you will need some knowledge of at least one of these languages to write your own functions.

This section describes the calling procedures for UDFs and explains how to make them operate in the MySQL environment. This section, together with the information contained in Day 13, “Using the C API,” is enough to get you coding, provided that you already have a reasonable knowledge of C or C++.

Datatypes and Calling Sequences

As explained previously, a user-defined MySQL function MYFUNC() will have a corresponding C function called myfunc(). In addition, it ...

Get Sams Teach Yourself MySQL in 21 Days, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.