MySQL

Use the MySQL node to automate work in MySQL, and integrate MySQL with other applications. Mosaic Workflows has built-in support for a wide range of MySQL features, including executing an SQL query, as well as inserting, and updating rows in a database.

On this page, you'll find a list of operations the MySQL node supports and links to more resources.

Operations

• Delete
• Execute SQL
• Insert
• Insert or Update
• Select
• Update

Use query parameters

When creating a query to run on a MySQL database, you can use the Query Parameters field in the Options section to load data into the query. Mosaic Workflows sanitizes data in query parameters, which prevents SQL injection.

For example, you want to find a person by their email address. Given the following input data:

[
    {
        "email": "alex@example.com",
        "name": "Alex",
        "age": 21 
    },
    {
        "email": "jamie@example.com",
        "name": "Jamie",
        "age": 33 
    }
]

You can write a query like:

SELECT * FROM $1:name WHERE email = $2;

Then in Query Parameters, provide the field values to use. You can provide fixed values or expressions. For this example, use expressions so the node can pull the email address from each input item in turn:

// users is an example table name
users, {{ $json.email }}