SELECT COMMANDS IN MYSQL

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