AcademyWorkflowsData and reporting

Create a Table in MySQL and Insert Data

Data and development teams learning how the MySQL node works in n8n.

  • Recommendedour rating
  • 6,128views on n8n
Open on n8n.io ↗

Paste it straight onto an n8n canvas with Ctrl+V or Cmd+V.

create-a-table-in-mysql-and-insert-data.json

Loading the file...

What it does

This is a companion n8n workflow for the MySQL node documentation. It shows how to create a table in a MySQL database and insert data into it. The description does not list further steps, so check the nodes inside the workflow before you run it against a real database.

Use cases

  1. 01Learn how to create a table from a workflow
  2. 02Test inserting rows into a MySQL database
  3. 03Use it as a starting point for a MySQL flow

Connects

MySQL

Questions about
Create a Table in MySQL and Insert Data.

What is Create a Table in MySQL and Insert Data used for?

Data and development teams learning how the MySQL node works in n8n. This is a companion n8n workflow for the MySQL node documentation. It shows how to create a table in a MySQL database and insert data into it. The description does not list further steps, so check the nodes inside the workflow before you run it against a real database.

How do I import Create a Table in MySQL and Insert Data into n8n?

Copy the workflow JSON from this page and paste it onto the n8n canvas with Ctrl+V or Cmd+V. Then connect your credentials in each node.

Is Create a Table in MySQL and Insert Data safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.