Database table creation and data insertion in MySQL

• Automate the creation of database tables in MySQL
• Insert predefined data into MySQL tables
• Streamline database management processes

Manually trigger the workflow to start the process Execute a SQL query to create a new table in MySQL Set values for the table columns Insert the defined values into the created table

1. 1
   Import the workflow template into n8n
2. 2
   Click on 'execute' to initiate the workflow
3. 3
   Review the SQL query for table creation
4. 4
   Adjust column values in the Set node if needed
5. 5
   Run the workflow to create the table and insert data