SQL_NO_CACHE

http://dev.mysql.com/doc/refman/5.7/en/query-cache-in-select.html

MySQL 5.7 Reference Manual  /  ...  /  Query Cache SELECT Options

9.10.3.2 Query Cache SELECT Options

Two query cache-related options may be specified in SELECT statements:

  • SQL_CACHE

    The query result is cached if it is cacheable and the value of the query_cache_type system variable is ON or DEMAND.

  • SQL_NO_CACHE

    The server does not use the query cache. It neither checks the query cache to see whether the result is already cached, nor does it cache the query result.

Examples:

SELECT SQL_CACHE id, name FROM customer;
SELECT SQL_NO_CACHE id, name FROM customer;
posted @ 2016-11-19 13:24  papering  阅读(301)  评论(0编辑  收藏  举报