Interested to Buy Any Domain ? << Click Here >> for more details...
How can you "tell" MySQL server to cache a query?
- 2 Answers
- 5879 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 we can crop an image and how we can display it..
Can constructor be private in php?
What is the use of header in php?
Which is better php or wordpress?
Explain array_uintersect()?
What is a namespace in php?
How to convert a character to an ascii value?
Name some of the functions in php.
How many columns can be added in a table in mysql?
What type of comments are supported by PHP.
What is mysqli_query?
What are the final class and final method?
PHP 
