Save and reuse a query result

Run the statements in one session. LAST_QUERY_ID() is session context; save the ID before another query changes it. Add --comments when using the MySQL command-line client, or it will remove the /* save_result */ marker.

CREATE DATABASE cookbook_result;
CREATE TABLE cookbook_result.sales(id INT, amount INT);
INSERT INTO cookbook_result.sales VALUES(1,10),(2,20);
SET save_query_result = ON;
/* save_result */ SELECT id,amount FROM cookbook_result.sales ORDER BY id;
SET @saved_id = LAST_QUERY_ID();
SELECT id,amount FROM RESULT_SCAN(@saved_id) AS r ORDER BY id;
SELECT COUNT(*) AS saved_rows FROM RESULT_SCAN(@saved_id) AS r;
SELECT COUNT(*) AS metadata_rows FROM META_SCAN(@saved_id) AS m;
SET save_query_result = OFF;
DROP DATABASE cookbook_result;

Expect reused rows (1,10) and (2,20), saved_rows=2, and one result metadata row. Result size, visibility, and lifetime depend on system settings. See the source result reuse test.