How can you "tell" MySQL server to cache a query?
Answers were Sorted based on User's Feedback
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 |
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 |
Where is session value stored php?
What are classes in php?
What is the difference between query and question?
How does one prevent the following warning ‘warning: cannot modify header information – headers already sent' and why does it occur in the first place?
Why is node js better than php?
How to protect special characters in query string?
What is php used for?
What are the differences between require and include?
What is RSS?How to use it in Program?
What is difference between post and put in rest?
What is overloading and overriding in php?
What software is required to run php?