blob: d8cd261b60c44455b4d9d7daa0a525538a405222 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
To add the custom functions to your MySQL server use the following syntax:
(you may install only the functions you need):
USE mysql;
DROP FUNCTION IF EXISTS lib_mysqludf_xql_info;
DROP FUNCTION IF EXISTS xql_textdecl;
DROP FUNCTION IF EXISTS xql_pi;
DROP FUNCTION IF EXISTS xql_dtd;
DROP FUNCTION IF EXISTS xql_element;
DROP FUNCTION IF EXISTS xql_forest;
DROP FUNCTION IF EXISTS xql_concat;
DROP FUNCTION IF EXISTS xql_agg;
DROP FUNCTION IF EXISTS xql_comment;
DROP FUNCTION IF EXISTS xql_cdata;
DROP FUNCTION IF EXISTS xql_encode;
CREATE FUNCTION lib_mysqludf_xql_info RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE FUNCTION xql_textdecl RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE FUNCTION xql_pi RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE FUNCTION xql_dtd RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE FUNCTION xql_element RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE FUNCTION xql_forest RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE FUNCTION xql_concat RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE AGGREGATE FUNCTION xql_agg RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE FUNCTION xql_comment RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE FUNCTION xql_cdata RETURNS STRING SONAME 'lib_mysqludf_xql.so';
CREATE FUNCTION xql_encode RETURNS STRING SONAME 'lib_mysqludf_xql.so';
Example for deinstalling a function:
DROP FUNCTION xql_encode;
For function descriptions, see the following webpage:
http://http://www.mysqludf.org/lib_mysqludf_xql/index.php
|
