DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) Query Cache in SELECT

Info Catalog (mysql.info.gz) Query Cache How (mysql.info.gz) Query Cache (mysql.info.gz) Query Cache Configuration
 
 5.11.2 Query Cache `SELECT' Options
 -----------------------------------
 
 There are two query cache-related options that may be specified in a
 `SELECT' statement:
 
 `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.gz) Query Cache How (mysql.info.gz) Query Cache (mysql.info.gz) Query Cache Configuration
automatically generated byinfo2html