> For the complete documentation index, see [llms.txt](https://cgps.gitbook.io/data-flo/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://cgps.gitbook.io/data-flo/reference-guide/import-from-mysql.md).

# import-from-mysql

## Description

<mark style="color:purple;">`import-from-mysql`</mark> *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.