Answer Posted / 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

How do I restore a mysql database?

1142

---

what is the procedure to configure the application of mysql?

1100

---

How can you export the table as an xml file in mysql?

930

---

What mysql means?

1012

---

What is default schema in mysql?

974

---

What is append query?

962

---

Is mysqli faster than mysql?

982

---

How to create a new table by selecting rows from another table in mysql?

1052

---

What is ndb in mysql?

1015

---

What are queries used for?

1001

---

What are the advantages/disadvantages of mysql and php?

999

---

What does it mean to be case sensitive?

1063

---

What are the drivers in MySQL?

1542

---

How to return query output in xml format?

1088

---

1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

2583

---