(mysql.info) query-cache-in-select

Info Catalog

(mysql.info) query-cache-how

(mysql.info) query-cache

(mysql.info) query-cache-configuration

 
 5.14.2 Query Cache `SELECT' Options
 -----------------------------------
 
 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'.
 
    * `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;
 

Info Catalog

(mysql.info) query-cache-how

(mysql.info) query-cache

(mysql.info) query-cache-configuration