MySQL node

Import CSV into MySQL

Published 1 year ago

Created by

eduard
Eduard

Categories

Engineering
Building Blocks

Template description

This workflow demonstrates how CSV file can be automatically imported into existing MySQL database.

_25n8nworkflow.png

Before running the workflow please make sure you have a file on the server:

/home/node/.n8n/concerts-2023.csv

And the content of the file is the following:

Date,Band,ConcertName,Country,City,Location,LocationAddress,
2023-05-28,Ozzy Osbourne,No More Tours 2 - Special Guest: Judas Priest,Germany,Berlin,Mercedes-Benz Arena Berlin,"Mercedes-Platz 1, 10243 Berlin-Friedrichshain",
2023-05-08,Elton John,Farewell Yellow Brick Road Tour 2023,Germany,Berlin,Mercedes-Benz Arena Berlin,"Mercedes-Platz 1, 10243 Berlin-Friedrichshain",
2023-05-26,Hans Zimmer Live,Europe Tour 2023,Germany,Berlin,Mercedes-Benz Arena Berlin,"Mercedes-Platz 1, 10243 Berlin-Friedrichshain",
2023-07-07,Depeche Mode,Memento Mori World Tour 2023,Germany,Berlin,Olympiastadion Berlin,"Olympischer Platz 3, 14053 Berlin-Charlottenburg",

The detailed process is explained in the tutorial
https://blog.n8n.io/import-csv-into-mysql

Share Template

Implement complex processes faster with n8n

red icon yellow icon red icon yellow icon