Templates / Compare SQL datasets

Compare SQL datasets

Ready for 3.0

by n8n Team ✓ · 3,032 views · created 2023-09-11 · Engineering

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 5 nodes and runs manually, when you click “Execute workflow”. Along the way it connects MySQL.

How it runs

Trigger: Manually, when you click “Execute workflow”.

  1. Orders from 2003 and (MySQL): run a query
  2. Orders from 2004 and (MySQL): run a query
  3. Compare Datasets: uses Compare Datasets
  4. Change ordercount (Edit Fields (Set)): sets or maps fields

Services it uses

MySQL

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (4)

From the author

This workflow compares 2 datasets from a single database. Two SQL nodes create a slightly different summary report based on the payments table. Both reports have the same structure, but different time periods. In addition to that, output from the "Orders from…

Excerpt from n8n Team's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.