summaryrefslogtreecommitdiff
path: root/databases/mysql-udf-sys/pkg-message
blob: e0cbb3788f02bfbdd633aad02527f82fec8ddd2a (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

To add the custom functions to your MySQL server use the following SQL:
(These function can be dangerous, you should install only the functions
you need):

USE mysql;

CREATE FUNCTION
    lib_mysqludf_sys_info RETURNS string SONAME 'lib_mysqludf_sys.so';
CREATE FUNCTION sys_get RETURNS string SONAME 'lib_mysqludf_sys.so';
CREATE FUNCTION sys_set RETURNS int SONAME 'lib_mysqludf_sys.so';
CREATE FUNCTION sys_exec RETURNS int SONAME 'lib_mysqludf_sys.so';
CREATE FUNCTION sys_eval RETURNS string SONAME 'lib_mysqludf_sys.so';

To deinstall:

DROP FUNCTION IF EXISTS lib_mysqludf_sys_info;
DROP FUNCTION IF EXISTS sys_get;
DROP FUNCTION IF EXISTS sys_set;
DROP FUNCTION IF EXISTS sys_exec;
DROP FUNCTION IF EXISTS sys_eval;

For function descriptions, see the following webpage:
http://www.mysqludf.org/lib_mysqludf_sys