Development of a database of Internet resources does not differ from standard databases developed in the system of MS SQL SERVER. As a rule, MY SQL is used for such resources , although it can also be applied to the development of standard software products for local use. But the article will not discuss this.
, . , , , , . , , «» . MySQL – Join.
Join
, , , ( , , ). - Join. My SQL. , - «».
MySQL – Join, , . , , : .
, , , . ( ) :
- Inner join.
- Cross Join.
- Left join.
- Right Join.
, , .
, , , , . , , .
, .
, .
, . .
Inner Join
MySQL – Join Ineer . , . ? – ID, .
, , . Select , - , .
, . , , Inner Join. , MySQL Inner Join, , . . My SQL . , MySQL Inner Join.
, - . :
Using, , . , , .
, «on» , . :
Left Join
MySQL – Join, , . Left.
Left Join MySQL , Inner, , .
, . , , , "", , Left null, , .
, , , , .
Left
Left Join MySQL . , , , . , , , .
Where Join
, , , Where.
, , . Join , .
MySQL Join – Where , , , :
, . , .
Join
Join, , . , , . . , Join . , , .
. , . , . Update Join. Join , , , , .
. . . , ? MySQL Update Join :
, . . , , , .
( MySQL Join) . , . , MySQL Left Join .
58 , . . , - «123». (), – .
, .
, , . .
, , , , , , , , . MySQL Join Select :
MySQL, . Join , , , .