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

A select query over a large table runs very slow because of the growing number of entries in that table. What different measures could be taken to improve speed?

5 Answers  

---

What is the use of mysql_close()?

0 Answers  

---

What is text in mysql?

0 Answers  

---

If you specify the data type as DECIMAL (5,2), what?s the range of values that can go in this table?

2 Answers  

---

Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?

0 Answers  

---

What are the difference between and myisam and innodb?

0 Answers  

---

How will show all records containing the name "sonia" and the phone number '9876543210'

0 Answers  

---

What is sharding in mysql?

0 Answers  

---

Is mysql server free?

0 Answers  

---

What is a string in mysql?

0 Answers  

---

What is difference between group by and order by clause?

0 Answers  

---

Is mysql a odbc?

0 Answers  

---