Answer / Abhishek Pawar

The Query Cache in MySQL stores recently executed SQL statements along with their results. This caching mechanism can improve the overall performance of the database system by reusing pre-computed results instead of executing the same queries multiple times. However, it should be noted that the query cache is turned off by default in many MySQL configurations.

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

1 Answers   TCS,

---

How do you write an inner join query?

1 Answers  

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

1 Answers  

---

What is autocommit sql?

1 Answers  

---

How to get help at the sql prompt?

1 Answers  

---

Which is better trigger or stored procedure?

1 Answers  

---

If a cursor is open, how can we find in a pl/sql block?

0 Answers  

---

Is grant a ddl statement?

1 Answers  

---

hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification

1 Answers  

---

What is pl sql block structure?

1 Answers  

---

what are the disadvantages of mysql? : Sql dba

1 Answers  

---

Can we use insert statement in function?

1 Answers  

---