MySql

This extension contains functions for displaying data from MySQL databases.  Related Links: Extension Overview, DekiScript Overview, Extension Demos.

Assembly: mindtouch.deki.services
SID: sid://mindtouch.com/2007/06/mysql

This service requires Deki Wiki 1.8.2 or later.

To enable this extension, follow these steps:

1. Go to Service management in the Control Panel of your wiki.
2. Under Add Service, click on Local, and select type Extension.
3. Enter a description and the extension SID: sid://mindtouch.com/2007/06/mysql
4. Add any additional configuration settings that are required by the extension (see below).
5. Click on add service.

Configuration:

Before the MySql service can be used, it must be configured with the access information to the database.

If you need to configure multiple databases for the same wiki, register this extension once for each database.  Use the following preference to specify a unique namespace value for each registration.  Invoke the service using this value instead of mysql.  For example, if you set namespace=mydb1, you would invoke the service with mydb1.table("...") instead of mysql.table("...").

Functions:

MySql.Table(query : str) : xml

Show results of a SELECT query in a sortable table.

Parameters:

Name	Type	Description
query	str	SELECT query.

Samples:

	Output
To embed a SELECT query that displays a list of all users in the users table: {{ mysql.table("SELECT user_name as Name, user_email as Email FROM users") }}

---