MySQL: Create Table and Insert Sample Data

This workflow serves as a companion example for n8n's MySQL node documentation. It starts with a manual trigger, executes a SQL query to create a simple table named 'test' with columns 'id' (INT, primary key) and 'name' (VARCHAR(255)), sets sample data (id as number, name as 'n8n'), and inserts it into the table.

Benefits include quick setup for testing MySQL connections, understanding query execution vs. insert operations, and automating basic DB initialization. It's lightweight, requiring only MySQL credentials, making it perfect for beginners or proof-of-concept automations.

Use cases: Initialize databases for apps, seed test data for development, or integrate into larger workflows for dynamic table creation/insertion in IT ops, reporting tools, or any data pipeline needing MySQL setup. Easily customizable for production by parameterizing queries and data sources.