RESULT_SCAN
Retrieves the cached result of a previous query by its query ID.
See also: system.query_cache
Syntax
RESULT_SCAN('<query_id>' | LAST_QUERY_ID())
Examples
This example shows how to enable the query result cache and run a query whose result will be cached:
# Enable the query result cache feature
mysql> SET enable_query_result_cache = 1;
Query OK, 0 rows affected (0.01 sec)
# Cache all queries regardless of how fast they execute
mysql> SET query_result_cache_min_execute_secs = 0;
Query OK, 0 rows affected (0.01 sec)
# Execute a query and cache its result
mysql> SELECT * FROM t1 ORDER BY a;
+------+
| a |
+------+
| 1 |
| 2 |
| 3 |
+------+
3 rows in set (0.02 sec)
Read 0 rows, 0.00 B in 0.006 sec., 0 rows/sec., 0.00 B/sec.
Once the result is cached, you can use RESULT_SCAN
to retrieve it without re-running the query:
# Retrieve the cached result of the previous query using its query ID
mysql> SELECT * FROM RESULT_SCAN(LAST_QUERY_ID()) ORDER BY a;
+------+
| a |
+------+
| 1 |
| 2 |
| 3 |
+------+
3 rows in set (0.02 sec)
Read 3 rows, 13.00 B in 0.006 sec., 464.06 rows/sec., 1.96 KiB/sec.