Answer / mala yadav

select command is used to fetch the result from the table ,
but of u want the combine results from more than 1 table
then in this case we use JOINS rather than a single table
select statement.

In joins u can join upto 2 to 61 tables to get tha required
result.

joins are of 5 types
- inner join
- self join
- cross join
- left outer join
- right outer join

Answer / vishal

if u donot know join means u always working in one table but
always single table is not enough to give the result than
comes the concept of joins in which two table we join must
have a column same on the basis of the table are join. join
are of various type such as left outer, right outer ,inner
join etc

I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?

4 Answers  

---

Which mysql function is used to concatenate string?

1 Answers  

---

In how many ways we can retrieve data in the result set of mysql using php?

0 Answers  

---

What are CSV tables?

1 Answers  

---

What is pdo :: fetch_assoc?

0 Answers  

---

What is a storage engine?

0 Answers  

---

How can I see all mysql databases?

0 Answers  

---

What does mysql flush tables do?

0 Answers  

---

What is the current version of mysql?

0 Answers  

---

Why we use mysql workbench?

0 Answers  

---

What is mysqlcheck do?

0 Answers  

---

How can we run batch mode in mysql?

0 Answers  

---