MySQL Component

Query and manage data in a MySQL Database
Component key: mysql#
DescriptionMySQL is a popular relational database system. This component allows you to query a MySQL database.
This component returns data as an object that can be used in subsequent steps.
Instead of generating dynamic queries and sanitizing SQL yourself, you can use generic queries with parameter placeholders using the ?
placeholder.
You can use the placeholder several times in your query, and provide a list of optional parameters to the action.
For example, you can enter a query that reads INSERT INTO users (name, email) VALUES (?, ?)
.
Then, configure the optional parameters input to look like the following, ["myUsername", "myEmail"]
or whatever values you like.
Values provided for name and email are sanitized automatically.
#
MySQL Connections#
mySQL ConnectionCreate 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 | Default | Notes |
---|---|---|
Input Database string / Required | Default | Notes Provide a string value for the name of the database. |
Input Host string / Required | Default 192.168.0.1 | Notes Provide a string value for the address your MySQL server is hosted on. |
Input Password string | Default | Notes |
Input Port string / Required | Default 3306 | Notes Provide a string value of the port your database server is exposing. |
Input Username string | Default | Notes |
#
Actions#
QueryReturns the results of a MySQL database query | key: query
Input | Default | Notes | Example |
---|---|---|---|
Input Connection connection / Required | Default | Notes | Example |
Input Parameters data Value List | Default | Notes Optional parameters to insert into a query. | Example ["Example value to be inserted"] |
Input Query string / Required | Default SELECT * FROM `table` WHERE `name` = ? AND `age` > ? | Notes Provide a string containing a query to be executed by the MySQL server | Example |