MYSQL n8n INTEGRATION: AUTOMATE MYSQL WITH N8N

The Update action modifies existing records in your MySQL database. When data changes in external systems—a customer updates their email, an order status changes, a subscription renews—this action ensures your database reflects the current state.

Key parameters: Credential to connect with (required dropdown to select your MySQL account credentials with edit icon for managing credentials), Operation (configured to "Update" to modify existing records rather than creating new ones, typically combined with conditions to target specific rows), and Table (required dropdown where you select which table contains the records you want to update, with "From list" option populating available tables from your connected database).

Use cases: Update customer email addresses when they change in your CRM, mark orders as "shipped" when your fulfillment system confirms dispatch, or increment a counter field each time a specific event occurs.

The Select action retrieves data from your MySQL database based on criteria you define. This is your go-to operation when you need to fetch records to use in subsequent workflow steps—whether that's sending personalized emails, updating external systems, or making decisions based on database values.

Key parameters: Credential to connect with (required dropdown used to select an existing MySQL account credential configured within n8n, currently showing "MySQL account" with an edit icon for modifying credentials), Operation (required dropdown set to "Select" to retrieve data from the database), and Table (required field allowing you to specify which database table the operation will act upon, with dropdown set to "From list" and placeholder text "Select a Table...").

Use cases: Fetch all customers who signed up in the last 24 hours to send a welcome email sequence, retrieve product inventory levels to check stock before processing an order, or pull user preferences from a settings table to personalize notifications.

The Insert or Update action (commonly called "upsert") intelligently handles records that may or may not already exist. If a matching record is found, it updates; if not, it inserts. This eliminates the need for complex "check-then-act" logic in your workflows.

Key parameters: Credential to connect with (required dropdown for selecting an existing MySQL account credential configured within n8n, set to "MySQL account" with an edit icon for modifications), Operation (required dropdown configured to "Insert or Update", indicating the action will either add new records or modify existing ones based on matching criteria defined in subsequent configuration steps), and Table (required field specifying which database table the operation will act upon, using a dropdown allowing selection "From list" with placeholder "Select a Table...").

Use cases: Sync contact information from your CRM—update if the contact exists, create if they're new, maintain a "last seen" timestamp for users that updates on each interaction, or keep inventory counts synchronized without worrying about whether a product record exists.

The Insert action adds new records to your MySQL database tables. Every time your workflow processes incoming data—whether from a webhook, form submission, or another application—this action creates a corresponding database entry.

Key parameters: Credential to connect with (required dropdown to select your pre-configured MySQL account credentials for secure database connection), Operation (set to "Insert" to add new data rows, with other operations like Update, Delete, and Select serving different purposes), and Table (required field consisting of two parts—a dropdown set to "From list" that lets you choose how to specify the table, and a selection field where you pick the specific table for insertion).

Use cases: Log every form submission from your website into a leads table, create order records when customers complete checkout in your WooCommerce e-commerce system, or insert webhook payloads as raw event logs for later analysis.

The Execute SQL action gives you full control by letting you write and execute custom SQL queries. When the standard CRUD operations aren't enough—you need joins, aggregations, subqueries, or complex filtering—this action handles it.

Key parameters: Credential to connect with (required dropdown for selecting your pre-configured MySQL account credentials set to "MySQL account"), Operation (set to "Execute SQL" enabling custom query execution rather than predefined operations), Query (required multiline text input where you write your SQL statement, with interface reminder about using query parameters to prevent SQL injection attacks), and Options (optional expandable section where you can add query parameters and other advanced settings, currently showing "No properties" with an "Add option" button for adding parameters dynamically).

Use cases: Run complex SELECT queries with JOINs across multiple tables, execute aggregate functions (COUNT, SUM, AVG) for reporting workflows, or perform batch operations with a single optimized query.

The Delete action removes records from your MySQL database based on specified conditions. Use this for data cleanup, removing outdated entries, or implementing "hard delete" functionality in your applications.

Key parameters: Credential to connect with (required dropdown to select your MySQL account credentials for authentication), Operation (set to "Delete", indicating this action will remove rows from your specified table—always double-check your conditions before running delete operations), and Table (required field to specify which table to delete from, offering "Fixed" and "Expression" input methods where Fixed lets you select from a list while Expression allows dynamic table selection based on workflow data).

Use cases: Remove unverified user accounts older than 30 days, delete completed tasks from a queue table after processing, or clean up temporary session data on a scheduled basis.