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
Can I copy mysql data directory?
How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
What is session variable in mysql?
What is ibdata1?
How do you rename a table?
How you can create a trigger in mysql?
What are the indexes in mysql?
How do I change a procedure in mysql?
Why we use mysqli instead of mysql?
What is the maximum no of columns a table can have?
How do I rename a procedure?
Is mysql a database?
How do I edit a table in mysql workbench?
How do I rename a table in mysql?
What is the data type for file in mysql?