To query MariaDB with Flux:
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
mysql driver uses the following data source name (DSN) syntax (also known as a connection string):
MariaDB to Flux data type conversion
sql.from() converts MariaDB data types to Flux data types.
|MariaDB data type||Flux data type|
|INT, BIGINT, SMALLINT, TINYINT||int|
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for Flux and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.