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 |
How do I install mysql on windows 7?
Can mysql and mariadb coexist?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
How many rows mysql can handle?
What are the advantages/disadvantages of mysql and php?
Explain Access Control Lists.
What does tinyint mean?
What is ntext?
Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?
Is sql similar to mysql?
date funciton
How Switch (select or use) to a database.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)