Interested to Buy Any Domain ? << Click Here >> for more details...
How can you "tell" MySQL server to cache a query?
- 2 Answers
- 6146 Views
- I also Faced
- E-Mail Answers
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 session_register()?
Explain what is the use of "echo" in php?
What are session variables in php?
Tell us what is the difference between session_unregister() and session_unset()?
How do you display the output directly to the browser?
Do you know what is use of count() function in php?
How to create and destroy cookies in php?
What are the popular frameworks in php?
What is the difference between Reply-to and Return-path in the headers of a mail function?
How to remove leading and trailing spaces from user input values?
Extract url from this string? It should be flexible for all strings, not for this string only. "yahoo.comyahoo.co.inhotmail.org"
equivalent code for the following c program in php void main() { int i=5;printf("%d",i); }
PHP 
