Query MySQL

To query MySQL with Flux:

1. Import the sql package.

2. Use sql.from() and provide the following parameters:

   • driverName: mysql
   • dataSourceName: See data source name
   • query: SQL query to execute

import "sql"

sql.from(
    driverName: "mysql",
    dataSourceName: "user:password@tcp(localhost:3306)/db",
    query: "SELECT * FROM example_table",
)

MySQL data source name

The mysql driver uses the following data source name (DSN) syntax (also known as a connection string):

username:password@tcp(localhost:3306)/dbname?param=value

MySQL to Flux data type conversion

sql.from() converts MySQL data types to Flux data types.