import-from-mysql

Description

import-from-mysql adaptor imports data from a MySQL database and returns the results as a datatable in Data-flo.

This adaptor allows users to set up a connection to a database, set a query, and extract data from the database into a Data-flo datatable.

Inputs

hostname Type: text Required: Yes The hostname (e.g., localhost) or the IP address (e.g,. 127.0.0.1) of the database server.

port Type: number Required: No The port of the database server. If unspecified, defaults to 3306.

database Type: text Required: Yes The name of the database.

username Type: text Required: No The username to connect to the database.

password Type: text Required: No The password to connect to the database.

query Type: text Required: Yes The SQL query reading from the database (e.g., SELECT * from table WHERE ...).

Outputs

data Type: datatable A datatable containing the imported data.

Examples

Example 1: Default behaviour.

Inputs:

hostname: localhost

port: 3306

database: demoDB

username: demo_user

password: demo_password

query:

SELECT 1 AS field1, 'a' AS field2
UNION
SELECT 2 AS field1, 'b' AS field2
UNION
SELECT 3 AS field1, 'c' AS field2

Outputs:

data:

field1	field2
1	a
2	b
3	c

-> Imported data from MySQL database into Data-flo.