Creating MySQL User-Defined Functions in C++ Has
Creating MySQL User-Defined Functions in C++ Has Never Been Easier
Yura Sorokin Principal Software Engineer Percona
2
User-Defined Functions (UDFs)
It is a way to extend MySQL with a new function that works like a native (built-in) MySQL function; i.e., by using a UDF you can create native code to be executed on the server from inside MySQL.
3
User-Defined Functions (UDFs)
1. Build a shared object (.so) with the function logic 2. Register this function in MySQL Server via CREATE
FUNCTION ... SONAME ... 3. Use it, say, in a SELECT statement 4. Unregister this function in MySQL Server via DROP
FUNCTION
4
Oversimplified Example
Implement native_reverse() function that would accept exactly one string argument and return a copy of it with characters in reverse order.
SELECT native_reverse('abcd'); -> 'dcba' SELECT native_reverse(NULL); -> NULL
Spoiler alert: there is already REVERSE() in MySQL ons.html#function_reverse
5
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- how to migrate from sap jco2 to sap jco3 and use
- elisp reference sheet github pages
- part i multiple choice questions 3 points each
- c monadic interface
- creating mysql user defined functions in c has
- 10 notes topics ii 1 stuff you may want use your
- programming in c assignment week 8
- optimizing away c exception handling
- statically scoped exceptions a typed foundation for
- c 6 vorlesung exceptions
Related searches
- creating a sign up sheet in word
- creating a worksheet in word
- creating a sign in sheet in word
- creating a sign up sheet in excel
- directorio de empresas 2019 in xls file
- creating passion in the workplace
- creating functions in java
- c mysql connection
- c users user my pictures
- de materia medica in english
- mysql list tables in schema
- creating functions in python 3