Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What?s the difference between query_cache_type 1 and 2?

Answer Posted / amith

The second one is on-demand and can be retrieved via SELECT
SQL_CACHE.

you can use SELECT /* SQL_CACHE */ id FROM ? - MySQL will
interpret the code inside comments, while other servers
will ignore it.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I get a list of table names in mysql?

873


What is row?

1033


What is the use of mysqli_query?

834


What is the difference between mysql_fetch_assoc and mysql_fetch_array?

970


Explain about the architecture of MYSQL?

925


How do I download a mysql community server?

833


How many ways we can retrieve the date in result set of mysql using php?

1045


Which is best pdo or mysqli?

850


What are the advantages and disadvantages of using mysql?

933


What is a blob datatype?

810


What is mysql slow query?

897


Why should I use mysql?

869


Which datatype is used for email in mysql?

908


all the queries used in sql

2585


What is prepared statement in mysql?

899