What?s the difference between query_cache_type 1 and 2?
- 1 Answers
- 6746 Views
- I also Faced
- E-Mail Answers
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 |
What is logs in mysql?
How to write query to select word java's from column employees and from emp table
What is the purpose of using a heap table?
Please suggest me any course and institute which provide training on the below skills. • Knowledge of data extraction concepts and tools • QMF (query management facility)queries • Experience and expertise in QMF queries • Excellent ability to write, read, and interpret QMF queries against the Source Data Warehouse base level (daily and monthly) and month-end affinity comp tables • RDBMS & ER • Knowledge of Relational Databases (RDBMS) and Entity Relationship (ER) Diagrams • SOURCE Data Warehouse • Experience and expertise in Source Data Warehouse or data warehouses on the mainframe. • MS SQL Server • Experience in MS SQL Server • Excellent skill in writing/interpreting SQL queries and running Data Transformation Services (DTS) or open query packages. • Knowledge of writing/interpreting Visual Basic code.
What is index length in mysql?
How do I insert multiple rows in a table?
What is 'mysqldump'?
How we can get the current date in mysql?
What is foreign key in mysql?
Where is mysql installed on linux?
What is blob storage?
How to list or view all databases from the mysql server.
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
