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 do you register one session ?
Write a program in php to check whether a number is prime or not?
Why do we use php?
What does csrf token mean?
What is difference between include and include_once in php?
hello experts good morning to everyone ! at present am now learning LAMP course sir( linux, apache,mysql and php) after finishing this course can i create my own website without investment is it possible ? please can any one tell sir and also tell me how can i upload my project after finishing the project in internet ? please tell the ways sir please send ur valuable suggestions to kiranpulsar2007@gmail.com
How can I retrieve values from one database server and store them in other database server using PHP?
What are string functions?
What is php and its uses?
When sessions ends?
How to get ip address of a server in php?
What types of images that PHP supports?