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 . |