Query MariaDB

To query MariaDB 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"
)

MariaDB 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

MariaDB to Flux data type conversion

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