SQL Queries without using cache

From UFP-UV Sakai Wiki

Jump to: navigation, search

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

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


-- WITH cache
SELECT SQL_CACHE id, name FROM customer;
-- WITHOUT cache
SELECT SQL_NO_CACHE id, name FROM customer;
Personal tools