Interested to Buy Any Domain ? << Click Here >> for more details...
How can you "tell" MySQL server to cache a query?
- 2 Answers
- 5992 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 |
How to remove duplicate values from a PHP Array?
Write a program to get lcm of two numbers using php?
How error handling is being handled by php?
How do you count numbers in php?
If the variable $a is equal to 5 and variable $b is equal to character a, what’s the value of $$b? Can anyone explain how's the value of $$b=100
15 Answers ABC, Asan, Indivar, Swistro Marketing Solutions,
What is php explain how php works?
Php being an open source is there any support available to it?
Is php a mvc?
What are the methods of array in java?
What are the file upload settings in configuration file?
List out some tools through which we can draw E-R diagrams for mysql.
What is meant by an associative array?
PHP 
