what is JOIN? Give example & types of join?
Answer Posted / neha gupta
The act of joining in MySQL refers to smashing two or more
tables into a single table.In short, a join command unites
some or all of the data from two or more tables into one
comprehensive structure.
Types of Join
1. Inner Join
2. Outer Join
Left Outer Join
Right Outer Join
3. Self Join
| Is This Answer Correct ? | 81 Yes | 12 No |
Post New Answer View All Answers
what is database black box testing? : Mysql dba
Is mysql a database?
How can I remotely connect to mysql database?
How do I assign a variable in mysql?
How do I backup mysql database on linux?
Can you tell which of the following where clauses is faster?
What is pragma serially_reusable and why is it used?
How to get data from mysql in php?
What is a heap table?
How can you handle the –secure-file-priv in mysql?
What is the difference between mysql and sql?
Give string types available for column?
What is mysql primary key?
Why are function needed?
What is use of mysql?