To query MySQL 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", )
MySQL data source name
mysql driver uses the following data source name (DSN) syntax (also known as a connection string):
MySQL to Flux data type conversion
sql.from() converts MySQL data types to Flux data types.
|MySQL 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.