Answer / santhi mundru

Merging two or three as a single table is called "join"
Types:
Inner Join
Outer Join
right outer join
left outer join
self join.

Answer / sahib

the relationship between two or more tables
Types of join:
Three Types of joning

Answer / santosh

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

Answer / sriram

outer join

How to change the database engine in mysql?

0 Answers  

---

What are the 'mysql' command line options?

0 Answers  

---

What is identity in mysql?

0 Answers  

---

Consider you have the following three tables which have to be linked together.

0 Answers  

---

I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?

0 Answers  

---

---

at first i'm using datediff('d', a.due_date, current_date); but it takes too long to get the result but how can i subtract the current_date - a.due_date and still get the same result like when i use datediff? thank you

1 Answers  

---

What can you do with mysql?

0 Answers  

---

What is trigger in mysql with example?

0 Answers  

---

What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?

2 Answers  

---

How to delete a trigger in mysql?

0 Answers  

---

What is a simple query?

0 Answers  

---

What is the purpose of using ifnull() function?

0 Answers  

---