Answer Posted / antergen suvi danis

Join Syntax:

table_references:
table_reference [, table_reference] ...

table_reference:
table_factor
| join_table

table_factor:
tbl_name [[AS] alias] [index_hint)]
| table_subquery [AS] alias
| ( table_references )
| { OJ table_reference LEFT OUTER JOIN table_reference
ON conditional_expr }

join_table:
table_reference [INNER | CROSS] JOIN table_factor
[join_condition]
| table_reference STRAIGHT_JOIN table_factor
| table_reference STRAIGHT_JOIN table_factor ON
conditional_expr
| table_reference {LEFT|RIGHT} [OUTER] JOIN table_reference

join_condition
| table_reference NATURAL [{LEFT|RIGHT} [OUTER]] JOIN

table_factor

join_condition:
ON conditional_expr
| USING (column_list)

index_hint:
USE {INDEX|KEY} [FOR JOIN] (index_list)
| IGNORE {INDEX|KEY} [FOR JOIN] (index_list)
| FORCE {INDEX|KEY} [FOR JOIN] (index_list)

index_list:
index_name [, index_name] ...

Types of join are,

* Inner Join
* Left Join or Left Outer Join
* Right Join or Right Outer Join
* Equi join
* Non Equi Join
* Natural Join
* Straight Join

What is the insert?

873

---

Which software is used for mysql?

976

---

How do I get a list of table names in mysql?

923

---

What is auto increment in mysql?

958

---

How to use sum function in where clause in mysql?

961

---

What are the types of database engines available in mysql?

1033

---

Explain the different types of constraints?

944

---

What is the default port number of mysql?

945

---

How is data stored in mysql?

920

---

What is the default password for mysql?

893

---

How to represent ENUMs and SETs internally?

1127

---

What is innodb mysql?

1078

---

How do I use mysql?

884

---

What is limit in mysql?

860

---

How do I copy a table in mysql?

934

---