MySql

This library contains functions for displaying data from MySQL databases.  関連リンク: Extension Overview, DekiScript Overview, Extension Demos.

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

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:

1. mysql.table
   

mysql.table(query : str) : xml

Show results of a SELECT query in a 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") }}