Using Temporary Tables
Temporary tables store intermediate results within a session and are automatically dropped afterward.
CREATE TEMPORARY TABLE temp_sales AS SELECT * FROM sales WHERE sale_date > '2024-01-01';
Temporary tables store intermediate results within a session and are automatically dropped afterward.
CREATE TEMPORARY TABLE temp_sales AS SELECT * FROM sales WHERE sale_date > '2024-01-01';