# MySQL

MySQL (opens new window) is an open-source relational database management system. MySQL has stand-alone clients that allow users to interact directly with a MySQL database using SQL, but more often MySQL is used with other programs to implement applications that need relational database capability.

🔑 Credentials

You can find authentication information for this node here.

# Basic Operations


  • Execute an SQL query.
  • Insert rows in database.
  • Update rows in database.

# Example Usage

This workflow allows you to create a table and insert data in it on a MySQL database. You can also find the workflow (opens new window) on n8n.io. This example usage workflow would use the following nodes.

The final workflow should look like the following image.

A workflow with the MySQL node

# 1. Start node

The start node exists by default when you create a new workflow.

# 2. MySQL node (Execute Query)

  1. First of all, you'll have to enter credentials for the MySQL node. You can find out how to do that here.
  2. Select 'Execute Query' from the Operation dropdown list.
  3. Enter the following SQL query in the Query field: CREATE TABLE test (id INT, name VARCHAR(255), PRIMARY KEY (id));.
  4. Click on Execute Node to run the node.

Using the MySQL node to create a table

# 3. Set node

  1. Set the Keep Only Set toggle to true.
  2. Click on the Add Value button and select 'Number' from the dropdown list.
  3. Enter id in the Name field.
  4. Click on the Add Value button and select 'String' from the dropdown list.
  5. Enter name in the Name field.
  6. Enter the value for the name in the Value field.
  7. Click on Execute Node to run the node.

Using the Set node to set data to be inserted by the MySQL node

# 4. MySQL1 node (Insert)

  1. Select the credentials that you entered in the previous MySQL node.
  2. Enter test in the Table field.
  3. Enter id, name in the Columns field.
  4. Click on Execute Node to run the node.

Using the MySQL node to insert data into a table