MySQL

MySQL is a popular relational database system. This component allows you to query a MySQL database.

Connections

MySQL Connection {#mysql}

Authenticate requests to a MySQL server

Create a new MySQL connection and enter the host, port, and database for your MySQL server. The username and password are optional inputs that can be put directly into a MySQL connection.

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 {#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