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 grant privileges to a user in mysql phpmyadmin?

954


How to create table with same structure of student table in mysql?

951


What are features of mysql?

892


Does uninstalling mysql delete database?

1025


How to shutdown mysql server?

1068


What is unsigned int in mysql?

927


How to use triggers to track changes in mysql?

874


What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

916


What is the use of i-am-a-dummy flag in mysql?

1011


What is difference between oracle sql and mysql?

1019


What is regex in mysql?

1087


How to find second highest salary from a table?

1022


How large can a mysql database become?

1001


What is insert query in mysql?

908


How do I import database through command line?

1009