Answer Posted / shahzad

join clause is used combines records from two or more tables
in a database.it means combining fields from tables common
to each.

There are 4 common types of join
1-inner
2-outer
3-left
4-right
and special case is "" self-join ""

1-inner join
Equi-join
Natural join
Cross join
2-Outer joins
Left outer join
Right outer joins
Full outer join
other tpes are hash and merge join bu these are algorith
implementation.

What is the difference between the primary and unique key in mysql?

1034

---

How many mysql connections can handle?

949

---

What happens if null values are involved in expressions?

1086

---

Who developed mysql?

1073

---

How do you determine the location of mysql data directory?

984

---

What are the different tables present in MySQL?

1157

---

What is blob in mysql?

1087

---

How can you take the backup and restore a mysql database using php?

1009

---

what is the default port for mysql server? : Mysql dba

1102

---

What you can use regular expression for in mysql?

999

---

Do you need a license for mysql?

988

---

What is the return type of mysqli_query?

921

---

How do I view mysql logs?

934

---

Why mysql is open source?

971

---

How to show certain selected rows with the value "pcds".

982

---