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...

  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

What?s the difference between query_cache_type 1 and 2?

Question Posted / amith

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 sqlyog?

1033

How to extract a unit value from a date and time?

954

What is the difference between unix timestamps and mysql timestamps?

1017

How does php communicate with mysql?

916

What is the default password for mysql?

907

How do I start mysql in ubuntu?

1044

How to show table names with 'mysqlshow'?

1043

Why to use char instead of varchar in the database?

1199

Write a query to display current date and time?

930

What is myisamchk?

978

How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.

935

Explain csv tables.

1023

What is information_schema in mysql?

999

How to change a password for an existing user via mysqladmin?

987

can you tell what are the different set operations available in mysql? : Mysql dba

896