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
How do I get a list of table names in mysql?
What is row?
What is the use of mysqli_query?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
Explain about the architecture of MYSQL?
How do I download a mysql community server?
How many ways we can retrieve the date in result set of mysql using php?
Which is best pdo or mysqli?
What are the advantages and disadvantages of using mysql?
What is a blob datatype?
What is mysql slow query?
Why should I use mysql?
Which datatype is used for email in mysql?
all the queries used in sql
What is prepared statement in mysql?