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

Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

932

---

What is datadir?

822

---

What is timestamp in mysql?

940

---

How do I rename a table in mysql workbench?

904

---

How to convert character strings to numeric values?

1059

---

How do I drop a database in mysql?

1065

---

What is mysql procedure?

890

---

How do I tune a mysql query?

826

---

What is the insert?

834

---

How to delete a database from mysql server.

986

---

How to update info already in a table and delete a row(s) from a table.

819

---

How many ways we can retrieve the date in result set of mysql using php?

1046

---

Is sql and mysql same?

871

---

What is database clustering in mysql?

951

---

Is null in mysql?

814

---