Answer Posted / santosh

joins are three types
equity join
natural join
conditional joins
these joins use to create conection b\w thie attributes

What is difference between group by and order by clause?

909

---

How many columns can be used for creating Index?

984

---

What is difference between mysql and mariadb?

1029

---

Write a query to fetch duplicate records from a table using mysql?

883

---

What is definer in mysql?

911

---

What is mysql_query?

795

---

How to do login in mysql with unix shell.

1030

---

What is insert query in mysql?

845

---

How many rows we can insert in a mysql table?

911

---

How do I restore a database in mysql workbench?

925

---

What is difference between pdo and mysqli?

914

---

How do you know the version of your mysql server?

1094

---

What is schema in mysql?

851

---

How do I change the max connection in mysql?

891

---

How to create a new table in mysql?

979

---