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

What is “i_am_a_dump” flag in mysql?

1046


Can I use mariadb instead of mysql?

898


How do I setup a mysql database?

959


What does mysql flush privileges do?

918


How do I flush privileges in mysql?

981


Is mysql good for big data?

922


Why to use char instead of varchar in the database?

1161


How do you kill a long running query in mysql?

874


How to validate email addresses in mysql?

1094


What are the benefits of mysql?

922


What is query design?

893


What is the difference between now() and current_date()?

961


How do I import database through command line?

978


Can we use mysql and mysqli together?

972


How to do login in mysql with unix shell.

1083