MySQL Connector
Query and manage data in a MySQL Database
Connections
MySQL Connection
Authenticate requests to a MySQL server
| Input | Comments | Default |
|---|---|---|
| Host | The publicly-accessible address of your MySQL server. | my-server.example.com |
| Port | The port your database server is exposing. | 3306 |
| Database | The name of your database. | |
| Username | ||
| Password |
Actions
Query
Returns the results of a MySQL database query
| Input | Comments | Default |
|---|---|---|
| Query | A query to be executed by the MySQL server. Substitute parameters with '?' marks. | SELECT * FROM table WHERE name = ? AND age > ? |
| Parameters | Optional parameters to insert into a query. Use this when you know how many parameters your query uses ahead of time. Use either parameters or reference parameters, not both. | |
| Reference Parameters | Optional parameters to insert into a query. Use this when you don't know how many parameters your query uses ahead of time. Reference parameters from a previous step that returns an array. Use either parameters or reference parameters, not both. | |
| Connection |