mysql

MySQL Full Join (Simulated)

MySQL does not support FULL OUTER JOIN natively.

SELECT * FROM t1 LEFT JOIN t2 ON t1.id = t2.id UNION SELECT * FROM t1 RIGHT JOIN t2 ON t1.id = t2.id;

Since MySQL lacks FULL JOIN, it is often simulated with UNION of LEFT and RIGHT joins, resulting in complex plan with unions and temporary tables.

Interactive Execution Plan

EXPLAIN Output

Run: EXPLAIN FORMAT=JSON your_query; or EXPLAIN your_query;

Enter SQL EXPLAIN output to visualizeSupports PostgreSQL EXPLAIN ANALYZE, MySQL EXPLAIN, and SQLite EXPLAIN QUERY PLAN formats