Executes SQL Queries against a MySQL database and returns the results as an XML Document. Can be run In-Cloud and requires no additional drivers.


Revision History

3.0.0.6 Initial Release, version matched with other SQL* Nodes

Properties

Connection

Type: Connection Input
The Connection Property

Server
Type: String
The name or IP address of the server hosting the Microsoft SQL Server instance. Specify a DropPoint if you need to access a SQL instance that is not Internet-exposed.

Database
Type: String
The name of the database to connect to.

Username
Type: String
The username to be used for the connection.

Password
Type: Password
The SQL password to be used for the connection.

Query

Type: Multiline Text Input
The SQL Query text.

ResultXml

Type: Xml Output
The dataset returned by executing the query in Query .


RowsAffected

Type: Int32 Output
Returns the number of rows returned by executing the SQL query.


Custom Inputs

Add Custom Input Properties to this Node to provide additional SQL Parameters that will be set at runtime. This technique should always be used to execute queries that require input data in order to avoid SQL injection attacks.

Remarks

Use this Connector to execute queries against a specific MySQL server instance.

Examples

See https://flowgear.me/s/5ekBfTu for an example.

See Also

Microsoft SQL Query
ODBC Query
OLEDB Query

Did this answer your question?