Port details on branch 2022Q3 |
- mysql-xql Library provides XML output functions to MySQL server
- 1.0.0_3 databases
=0 1.0.0_3Version of this port present on the latest quarterly branch.
- BROKEN: unfetchable
DEPRECATED: Broken for more than 6 months This port expired on: 2016-07-04 IGNORE: is marked as broken: unfetchable
- Maintainer: syncer@gmail.com
- Port Added: 2010-09-23 02:36:22
- Last Update: 2016-07-04 20:48:24
- SVN Revision: 418057
- License: not specified in port
- WWW:
- http://www.mysqludf.org/lib_mysqludf_xql/index.php
- Description:
- The lib_mysqludf_xql library provides an array of functions,
which can be used to create XML output directly from MySQL
using a single SQL query. This prevents having to convert a
MySQL result to XML in a PHP script, Ruby script, etc.
The library provides the same functionality as SQL/XML, seen
in MS SQL server and Oracle. However it uses normal functions.
By using subqueries the same results as SQL/XML can be generated.
WWW: http://www.mysqludf.org/lib_mysqludf_xql/index.php
-
cgit ¦ GitHub ¦ GitHub ¦ GitLab ¦
- Manual pages:
- FreshPorts has no man page information for this port.
- pkg-plist: as obtained via:
make generate-plist - There is no configure plist information for this port.
- Dependency lines:
-
- mysql-xql>0:databases/mysql-xql
- No installation instructions:
- This port has been deleted.
- PKGNAME: mysql-xql
- Flavors: there is no flavor information for this port.
- distinfo:
- There is no distinfo for this port.
No package information for this port in our database- Sometimes this happens. Not all ports have packages.
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- gmake : devel/gmake
- Library dependencies:
-
- libxml2.so : textproc/libxml2
- libmysqlclient.so.18 : databases/mysql56-client
- There are no ports dependent upon this port
Configuration Options:
- No options to configure
- Options name:
- N/A
- USES:
- gmake libtool gnome mysql:
- pkg-message:
- 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
- Master Sites:
|