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
5892 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

Will react hooks replace redux?

920

Why do we show php code in browser?

1007

What is interface? Why it is used?

976

What is the function mysql_pconnect() useful for?

896

How check variable is set or not in php?

827

Which is not a file-related function in php?

1000

What is a class in php programing?

2507

How to protect special characters in query string?

904

What is null value in php?

988

What is the role of the .htaccess file in php?

908

Is laravel frontend or backend?

922

Tell me when a conditional statement is ended with an endif?

861

Code to open file download dialog in PHP?

1037

How I can control asset documents without GR/IR?

1588

What percentage of websites use php?

957