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

What is the meaning of symbol '$' in jquery?

1047

Explain how is it possible to set an infinite execution time for php script?

979

What are the three parts of an http request?

973

What is api used for?

911

How can we check the value of a given variable is a number?

1070

Explain some of the php array functions?

1061

What is php used for?

951

Which function can be used to exit from the script after displaying the error message?

944

Explain a resource?

996

What is cURL in PHP?

977

What is php artisan tinker?

971

Tell us how can we display the output directly to the browser?

1027

Why php is used with mysql?

1010

What is use of isset function in php?

1035

What is exception handling in php?

1598