🗄
SQL
Mem
v2 — MySQL Visualizer
SCHEMA
DML
SELECT/WHERE
JOIN
GROUP BY
⚙ EXEC ORDER
Tables
0
Rows
0
Relations
0
✕ CLEAR
▶ RUN
SQL EDITOR
▶ EXECUTE
✕
PRESETS
🏢 Company — employees, departments
🛒 E-Commerce — users, orders, products
🎓 School — students, courses, enrollments
DML OPERATION
OPERATION TYPE
INSERT
UPDATE
DELETE
TRUNCATE
TARGET TABLE
— select —
VALUES (comma-separated per row)
SET CLAUSE
WHERE CONDITION
WHERE CONDITION
⚠ TRUNCATE removes ALL rows instantly.
No WHERE clause. Cannot rollback easily.
Faster than DELETE for full wipe.
⚡ ANIMATE DML
SELECT / WHERE / ORDER
TABLE
— select —
SELECT COLUMNS
WHERE CLAUSE
FILTER TYPE
LIKE
IN
BETWEEN
IS NULL
IS NOT NULL
ORDER BY
ASC
DESC
LIMIT / OFFSET
⚡ ANIMATE QUERY
JOIN ANIMATOR
JOIN TYPE
INNER
LEFT
RIGHT
FULL
FROM TABLE
— select —
JOIN TABLE
— select —
ON CONDITION
⚡ ANIMATE JOIN
GROUP BY + AGGREGATES
TABLE
— select —
GROUP BY COLUMN
— none —
AGGREGATE FUNCTION
COUNT
SUM
AVG
MIN
MAX
ON COLUMN (for SUM/AVG/MIN/MAX)
— select col —
HAVING (optional)
Show NULL handling
⚡ ANIMATE AGGREGATION
// SQLMem v2 ready. Load a preset to begin.
SCHEMA
— no tables
RESULT
EXEC ORDER
EXPLAIN
Run any operation
to see results here.
SQL Execution Order — how MySQL actually processes your query:
Query Explanation:
⚙ SQL Execution Order
MySQL does NOT execute SQL in the order you write it. Here's the real order:
CLOSE
● READY
No query executed