SELECT
Two query cache-related options may be specified in SELECT statements:
SQL_CACHE
The query result is cached if the value of the query_cache_type system variable is ON or DEMAND.
query_cache_type
ON
DEMAND
SQL_NO_CACHE
The query result is not cached.
Examples:
SELECT SQL_CACHE id, name FROM customer; SELECT SQL_NO_CACHE id, name FROM customer;
