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

Question Posted / khirod

2 Answers
5522 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / ravi

$db = mysql_connect('localhost','username','password');
mysql_select_db("databasename", $db);
if (!$db)
{
die('Could not connect: ' . mysql_error());
}

$abc=mysql_query("write your query");

Is This Answer Correct ?

3 Yes

9 No

Post New Answer