Answer / hrindows@gmail.com

The SQL statement that is used to make a connection between two or more tables based on the matching columns is called a join. It is mainly used for complex queries.
Different types of SQL joins are mentioned below:
 Inner Join: It is a default join. It returns records when the values match in the joining tables.
 Left Outer Join: It returns all the records from the left table based on the matched records from the right table.
 Right Outer Join: It returns all the records from the right table based on the matched records from the left table.
 Full Outer Join: It returns all the records that match from the left or right table.

Explain MySQL optimization?

1 Answers  

---

Explain advantages of MyISAM over InnoDB?

1 Answers  

---

What is difference mysql and mysqli?

0 Answers  

---

What is pragma autonomous_transaction?

0 Answers  

---

In the below example, how many String Objects are created? String s1="I am Java Expert"; String s2="I am C Expert"; String s3="I am Java Expert";

1 Answers  

---

What different Stored Objects are supported in MySQL?

1 Answers  

---

How to get current MySQL version?

0 Answers  

---

How are mysql timestamps seen to a user?

0 Answers  

---

Differentiate between FLOAT and DOUBLE?

1 Answers  

---

How to create trigger in mysql phpmyadmin?

0 Answers  

---

Will mysql remain free?

0 Answers  

---

What are procedures in mysql? Explain

0 Answers  

---