Interested to Buy Any Domain ? << Click Here >> for more details...
How can you "tell" MySQL server to cache a query?
- 2 Answers
- 6144 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 the default time in seconds for which session data is considered valid?
Where session is stored?
What is the use of htmlentities in php?
What is csrf token in php?
How to create an array in php?
What are php data types?
How many types of inheritances used in php and how we achieve it.
What is the main difference between php 4 and php 5?
what are the basic steps to installation php4+mysql4+phpmyadmin on IIS web server?. Pls write the complete steps.
How to restrict the number of users login ? For ex:- if the allowed login is 10, for 11th user, the application should restrict them from login.
How to get a total number of rows available in the table?
What is the salary for php developer(Fresher)?
PHP 
