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?



What?s the difference between query_cache_type 1 and 2?..

Answer / 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

More MySQL Interview Questions

What are the non-standard sql commands supported by 'mysql'?

0 Answers  


What is foreign key in mysql?

0 Answers  


What is ISAM?

0 Answers  


what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

0 Answers  


How to store binary data in mysql?

0 Answers  


how do i list constraints in my database by using sql server2000?

1 Answers  


Can we write pl sql mysql?

0 Answers  


What is the latest version of php and mysql?

0 Answers  


What is difference between group by and order by clause?

0 Answers  


A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.

1 Answers  


What is the default port of mysql server?

0 Answers  


Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44&#8242; ON UPDATE CURRENT_TIMESTAMP.

1 Answers  


Categories