Import Csv Into Mysql

About This Script

Features:

• Automates workflow tasks
• Ready to import into n8n
• Configurable parameters

{
    "nodes": [
        {
            "id": "aecce7a8-24f6-48c0-a7f0-f48a421d1d8c",
            "name": "On clicking 'execute'",
            "type": "n8n-nodes-base.manualTrigger",
            "position": [
                540,
                400
            ],
            "parameters": [],
            "typeVersion": 1
        },
        {
            "id": "66822f20-83a9-4272-920c-5d8c9140f912",
            "name": "Read From File",
            "type": "n8n-nodes-base.readBinaryFile",
            "position": [
                740,
                400
            ],
            "parameters": {
                "filePath": "/home/node/.n8n/concerts-2023.csv"
            },
            "typeVersion": 1
        },
        {
            "id": "9b469774-7c1d-41a3-9bfe-18fc3527f96e",
            "name": "Convert To Spreadsheet",
            "type": "n8n-nodes-base.spreadsheetFile",
            "position": [
                940,
                400
            ],
            "parameters": {
                "options": {
                    "rawData": true,
                    "readAsString": true
                }
            },
            "typeVersion": 1
        },
        {
            "id": "a10bd105-16f7-47c8-b5a0-a5a10e51ae10",
            "name": "Insert into MySQL",
            "type": "n8n-nodes-base.mySql",
            "position": [
                1140,
                400
            ],
            "parameters": {
                "table": {
                    "__rl": true,
                    "mode": "name",
                    "value": "concerts_2023_csv"
                },
                "columns": "Date, Band, ConcertName, Country, City, Location, LocationAddress",
                "options": []
            },
            "credentials": {
                "mySql": {
                    "id": "46",
                    "name": "MySQL n8n articles"
                }
            },
            "typeVersion": 1
        }
    ],
    "connections": {
        "Read From File": {
            "main": [
                [
                    {
                        "node": "Convert To Spreadsheet",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "On clicking 'execute'": {
            "main": [
                [
                    {
                        "node": "Read From File",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "Convert To Spreadsheet": {
            "main": [
                [
                    {
                        "node": "Insert into MySQL",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        }
    },
    "n8n_version": "1.5.0"
}

Requirements