MySQL + SQL · Lesson 1
Pivot Table Mysql
What is a Pivot?
A pivot turns row values into columns — for example, showing monthly sales as separate columns. MySQL does this with CASE + SUM.
Pivot with CASE
SELECT product,
SUM(CASE WHEN month = 'Jan' THEN amount ELSE 0 END) AS Jan,
SUM(CASE WHEN month = 'Feb' THEN amount ELSE 0 END) AS Feb
FROM sales
GROUP BY product;product Jan Feb
------- ---- ----
Pen 100 150
Summary
- MySQL has no PIVOT keyword — use
SUM(CASE WHEN ... THEN ... END). - Each CASE becomes one new column; GROUP BY the row label.