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 |
How to get ip address of a server in php?
describe arguments in header in php?
What are the methods to submit form in php?
what are in image creating functions in php
Why do we use inheritance in php?
What is the expansion of LAMP?
Can php run on windows server?
Is php a web server?
What is the purpose of the '.myi' file extension? What do thes file contain?
•How to access crystal reports through PHP code?
How to use http headers inside php?
How to concatenate two strings in php?