Hi.. welcome to my blog at “We Are Knowledge”… in here you
will getting many IT knowledge. Likely this article discuss about “MYSQL”.. and
I want giving you tutorial about “Select”..
Surely you already know the command select in MYSQL. Surely
even you can also use the command, because the command is the basic command to
select a programming language
MYSQL. But how to display from many tables .. ? Discussed
in this article will be complete. ok let's read it friends.
Select command is a command to display the table in MYSQL.
we can choose what we will tamplikan, whether it's just a name, id, date of
birth, etc. to combine two or more tables we can use the command
"join".
There are 4 commands in MYSQL join, namely :
·
Inner Join
·
Outer Join
o
Left Join
o
Right Join
I'll discuss one by one..
1. Inner Join
To order the contents of the table will we connect the two
(2) directions, so there is never an empty or NULL data. In order merging the
data we can also use the command where. Where command is the command to perform
a condition, and the condition we write the following statement or command
where
2. Outer Join
As opposed to the "inner join" the merging of the
2 (two) directions, as on the "Outer join" us merge from 1 (one)
direction, thus allowing the data to blank or "not null". And this
order is OUTER JOIN divided into 2 (two) command again, namely: Left Join and
Right Join.
A. Left Join
Slightly different from the inner join, that the contents of
the table generated. If the Inner join that we make will be performing and
there contents, and left to join dataakan appear in the table but there are
parts that are NULL
B. Right Join
In this command, we relied on chart right.
Ok.. just it…
I hope you understand..
See you Later
No comments:
Post a Comment