MySQL
SQL commands targeting a MySQL database instance.
Types: mysql
Configuration
| Name | Required | Description |
|---|---|---|
MYSQL_HOST | yes | The MySQL database hostname. No formatting or port numbers, just the hostname. |
MYSQL_DB | yes | The name of the MySQL schema |
MYSQL_USER | yes | The database username |
MYSQL_PASS | yes | The database password |
MYSQL_PORT | no | Defaults to 3306 |
FIELD_SEPARATOR | no | Defaults to tab for mysql and to , for mysql-csv |
PRESERVE_COMMENTS | no | Preserve comments. Send comments to the server. The default is false. |