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

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

More PHP Interview Questions

Where is session value stored php?

0 Answers  


What are classes in php?

0 Answers  


What is the difference between query and question?

0 Answers  


How does one prevent the following warning ‘warning: cannot modify header information – headers already sent' and why does it occur in the first place?

0 Answers  


Why is node js better than php?

0 Answers  


How to protect special characters in query string?

0 Answers  


What is php used for?

0 Answers  


What are the differences between require and include?

0 Answers  


What is RSS?How to use it in Program?

3 Answers  


What is difference between post and put in rest?

0 Answers  


What is overloading and overriding in php?

0 Answers  


What software is required to run php?

0 Answers  


Categories