# MySQL

Frends offers seamless integration with [MySQL database](https://www.mysql.com), enabling you to effortlessly connect and automate data flows involving MySQL databases.

Frends provides tasks for performing all core MySQL operations.

By leveraging Frends' task-based approach, you can configure and customize MySQL integrations according to your specific requirements. Frends offers a wide range of tasks that facilitate integrations to a variety of systems and protocols.

## Use cases

Below you will find typical use cases for MySQL integrations and how they are implemented in Frends.

### Get data from the database and save as CSV

By using the [`ExecuteQuery`](https://docs.frends.com/tasks/tasks/mysql/executequery) task, we can create an integration that retrieves data from a MySQL database and generates CSV exports for further processing.

<figure><img src="https://2096450325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FevBo49UTUjEN84O2WPl6%2Fuploads%2Fgit-blob-de0c15d091c7453d0cdadf98b365d5eafa2fee83%2Fmysql-export.svg?alt=media" alt=""><figcaption><p>Export</p></figcaption></figure>

### Insert data to database

By using the file trigger and the [`ExecuteQuery`](https://docs.frends.com/tasks/tasks/mysql/executequery) task, we can create an integration that listens for incoming CSV files and inserts the data into the appropriate table in a Microsoft SQL database.

<figure><img src="https://2096450325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FevBo49UTUjEN84O2WPl6%2Fuploads%2Fgit-blob-e31243bc4e0bd691b9bc97065bfa039c168f91d6%2Fmysql-insert.svg?alt=media" alt=""><figcaption><p>Insert</p></figcaption></figure>