Yes you can tell Mysql to cache the query and not to cache the query with

How can you "tell" MySQL server to cache a query?

Question Posted / priti

2 Answers
5877 Views
I also Faced
E-Mail Answers

Answer Posted / priti

Yes you can tell Mysql to cache the query and not to cache
the query with following options

SQL_CACHE
SQL_NO_CACHE

SELECT SQL_CACHE id, name FROM your_table_name; //This will
get cached

SELECT SQL_NO_CACHE id, name FROM your_table_name; //This
will not get cached

(Related cache setting should also be effective for
SQL_CACHE).

Thanks

visit my profile and get helped on PHP and other issues on
http://pritisolanki.blogspot.com

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many escape sequences are recognized in double-quoted strings in php?

929

What are the two types of variables?

919

What is super keyword in php?

1006

How does php serialize work?

968

What is the difference between explode () and split () functions in php?

1062

What is serialization in php?

908

What is urlencode and urldecode in php?

1048

What is difference between echo and print in php?

875

Why json is used in php?

940

How to run a php script?

949

How long is csrf token?

869

Why do we use hooks?

855

What is the use of ajax in php?

934

What is a php namespace?

917

Explain me what is the difference between $_files['userfile']['name'] and $_files['userfile']['tmp_name']?

865