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 the difference between echo and print statement?
11 Answers Rushmore Consultancy,
Is php a framework?
What is the difference between php traits vs interfaces?
Why overriding is called runtime polymorphism?
How to run a php script?
How can we encrpt a text?
hi sir am a fresher just learning LAMP COURSE linux,apache,mysql and php .just i finished my M.C.A 2009 passed out ..can any one tell after i finish this course how much salary we expect in any php based company ? and also tell please how much salary we can demand as a fresher with my M.C.A qualification as a PHP fresher in a company ? how much we get atleast mininum as a PHP fresher in CHENNAI and Bangalore just send ur valuable suggestions to kiranpulsar2007@gmail.com please guide to me sir
What is the difference between urlencode and urldecode ?
How can we upload a php + mysql Site
Tell me how can we check the value of a given variable is alphanumeric?
What are the main error types in php and how do they differ?
how can attached a file to a mail and attached a resume to a mail and received in id