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 |
What is difference between get and post?
What is $_ get?
What are php data types?
Should I use mysqli or pdo?
Explain include(), include_once, require() and require_once?
How can I retrieve values from one database server and store them in other database server using PHP?
2 Answers DRC Systems, Photon,
What is meant by public, private, protected, static and final scopes?
How to open standard output as a file handle?
What is repository in php?
Difference between notify url, return url in paypal payment gateway?
4 Answers A1 Technology, Capital IQ, CMS, Essar, HCL, IAS, Karvy, L&T, State Bank Of India SBI, TATA, Tisco, WNS,
how many types of inheritance is there in php? name there?
How can we change the value of a constant?