This tutorial introduces the notion of a join. The database consists of three tables movie
, actor
and casting
.
movie |
actor |
casting |
id |
id |
movieid |
title |
name |
actorid |
yr |
|
ord |
director |
|
|
budget |
|
|
gross |
|
|
|
|
|
![mysql练习----More JOIN operations mysql练习----More JOIN operations](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwybHRZV2RsY3pJd01UVXVZMjVpYkc5bmN5NWpiMjB2WW14dlp5ODVNekl3TlRZdk1qQXhOekEwTHprek1qQTFOaTB5TURFM01EUXlOREl6TVRjd09UUTBOQzB4T1RVME16QTBNakl5TG5CdVp3PT0uanBn.jpg?w=700&webp=1)
movie
Field name |
Type |
Notes |
id |
INTEGER |
An arbitrary unique identifier |
title |
CHAR(70) |
The name of the film - usually in the language of the first release. |
yr |
DECIMAL(4) |
Year of first release. |
director |
INT |
A reference to the actor table. |
budget |
INTEGER |
How much the movie cost to make (in a variety of currencies unfortunately). |
gross |
INTEGER |
How much the movie made at the box office. |
Example
id |
title |
yr |
director |
budget |
gross |
10003 |
"Crocodile" Dundee II |
1988 |
38 |
15800000 |
239606210 |
10004 |
'Til There Was You |
1997 |
49 |
10000000 |
|
actor
Field name |
Type |
Notes |
id |
INTEGER |
An arbitrary unique identifier |
name |
CHAR(36) |
The name of the actor (the term actor is used to refer to both male and female thesps.) |
Example
id |
name |
20 |
Paul Hogan |
50 |
Jeanne Tripplehorn |
casting
Field name |
Type |
Notes |
movieid |
INTEGER |
A reference to the movie table. |
actorid |
INTEGER |
A reference to the actor table. |
ord |
INTEGER |
The ordinal position of the actor in the cast list. The
star of the movie will have ord value 1 the co-star will have
value 2, ...
|
Example
movieid |
actorid |
ord |
10003 |
20 |
4 |
10004 |
50 |
1 |
![mysql练习----More JOIN operations mysql练习----More JOIN operations](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwybHRZV2RsY3pJd01UVXVZMjVpYkc5bmN5NWpiMjB2WW14dlp5ODVNekl3TlRZdk1qQXhOekEwTHprek1qQTFOaTB5TURFM01EUXlOREl6TVRneE1UWTJNaTB4TkRJeE16VXhOemswTG5CdVp3PT0uanBn.jpg?w=700&webp=1)
![mysql练习----More JOIN operations mysql练习----More JOIN operations](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwybHRZV2RsY3pJd01UVXVZMjVpYkc5bmN5NWpiMjB2WW14dlp5ODVNekl3TlRZdk1qQXhOekEwTHprek1qQTFOaTB5TURFM01EUXlOREl6TVRnek1qSXdPUzAzTURrek16STJPRFl1Y0c1bi5qcGc%3D.jpg?w=700&webp=1)
![mysql练习----More JOIN operations mysql练习----More JOIN operations](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwybHRZV2RsY3pJd01UVXVZMjVpYkc5bmN5NWpiMjB2WW14dlp5ODVNekl3TlRZdk1qQXhOekEwTHprek1qQTFOaTB5TURFM01EUXlOREl6TVRreU1ERTNPQzAxTXpNd01UVXdNelF1Y0c1bi5qcGc%3D.jpg?w=700&webp=1)
![mysql练习----More JOIN operations mysql练习----More JOIN operations](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwybHRZV2RsY3pJd01UVXVZMjVpYkc5bmN5NWpiMjB2WW14dlp5ODVNekl3TlRZdk1qQXhOekEwTHprek1qQTFOaTB5TURFM01EUXlOREl6TVRrME1ERTBOeTAzTmpRMk1qSTBNRFl1Y0c1bi5qcGc%3D.jpg?w=700&webp=1)
![mysql练习----More JOIN operations mysql练习----More JOIN operations](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwybHRZV2RsY3pJd01UVXVZMjVpYkc5bmN5NWpiMjB2WW14dlp5ODVNekl3TlRZdk1qQXhOekEwTHprek1qQTFOaTB5TURFM01EUXlOREl6TVRrMU9ERTBOeTB4TmpjM056Y3pPVGswTG5CdVp3PT0uanBn.jpg?w=700&webp=1)
![mysql练习----More JOIN operations mysql练习----More JOIN operations](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwybHRZV2RsY3pJd01UVXVZMjVpYkc5bmN5NWpiMjB2WW14dlp5ODVNekl3TlRZdk1qQXhOekEwTHprek1qQTFOaTB5TURFM01EUXlOREl6TWpBME56TTJOUzB4TnpneU1qWTVNall6TG5CdVp3PT0uanBn.jpg?w=700&webp=1)
![mysql练习----More JOIN operations mysql练习----More JOIN operations](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwybHRZV2RsY3pJd01UVXVZMjVpYkc5bmN5NWpiMjB2WW14dlp5ODVNekl3TlRZdk1qQXhOekEwTHprek1qQTFOaTB5TURFM01EUXlOREl6TWpFeE16a3lPQzB5TURrd01UQTRORGd1Y0c1bi5qcGc%3D.jpg?w=700&webp=1)
![mysql练习----More JOIN operations mysql练习----More JOIN operations](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwybHRZV2RsY3pJd01UVXVZMjVpYkc5bmN5NWpiMjB2WW14dlp5ODVNekl3TlRZdk1qQXhOekEwTHprek1qQTFOaTB5TURFM01EUXlOREl6TWpFME5UUTNOUzB4TkRjNU1UTXdPRE14TG5CdVp3PT0uanBn.jpg?w=700&webp=1)
![mysql练习----More JOIN operations mysql练习----More JOIN operations](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwybHRZV2RsY3pJd01UVXVZMjVpYkc5bmN5NWpiMjB2WW14dlp5ODVNekl3TlRZdk1qQXhOekEwTHprek1qQTFOaTB5TURFM01EUXlOREl6TWpJeU5USTFOaTAyT0RRek5URTVOVE11Y0c1bi5qcGc%3D.jpg?w=700&webp=1)
![mysql练习----More JOIN operations mysql练习----More JOIN operations](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwybHRZV2RsY3pJd01UVXVZMjVpYkc5bmN5NWpiMjB2WW14dlp5ODVNekl3TlRZdk1qQXhOekEwTHprek1qQTFOaTB5TURFM01EUXlOREl6TWpJMU56QTROQzAyTVRjNU1qWXdOekl1Y0c1bi5qcGc%3D.jpg?w=700&webp=1)
![mysql练习----More JOIN operations mysql练习----More JOIN operations](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwybHRZV2RsY3pJd01UVXVZMjVpYkc5bmN5NWpiMjB2WW14dlp5ODVNekl3TlRZdk1qQXhOekEwTHprek1qQTFOaTB5TURFM01EUXlOREl6TWpNeE1UVTROQzA1T1RNeU5UQTNOUzV3Ym1jPS5qcGc%3D.jpg?w=700&webp=1)
![mysql练习----More JOIN operations mysql练习----More JOIN operations](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwybHRZV2RsY3pJd01UVXVZMjVpYkc5bmN5NWpiMjB2WW14dlp5ODVNekl3TlRZdk1qQXhOekEwTHprek1qQTFOaTB5TURFM01EUXlOREl6TWpNMU1EazVNQzB4TkRZNE5EZzVOemcxTG5CdVp3PT0uanBn.jpg?w=700&webp=1)
![mysql练习----More JOIN operations mysql练习----More JOIN operations](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwybHRZV2RsY3pJd01UVXVZMjVpYkc5bmN5NWpiMjB2WW14dlp5ODVNekl3TlRZdk1qQXhOekEwTHprek1qQTFOaTB5TURFM01EUXlOREl6TWpReE5qRXdNQzB4T0RRMk1UUTRNelk0TG5CdVp3PT0uanBn.jpg?w=700&webp=1)
![mysql练习----More JOIN operations mysql练习----More JOIN operations](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwybHRZV2RsY3pJd01UVXVZMjVpYkc5bmN5NWpiMjB2WW14dlp5ODVNekl3TlRZdk1qQXhOekEwTHprek1qQTFOaTB5TURFM01EUXlOREl6TWpRME1qRTBOeTB4TVRFNE5qWTFNamt4TG5CdVp3PT0uanBn.jpg?w=700&webp=1)
![mysql练习----More JOIN operations mysql练习----More JOIN operations](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhCekwybHRZV2RsY3pJd01UVXVZMjVpYkc5bmN5NWpiMjB2WW14dlp5ODVNekl3TlRZdk1qQXhOekEwTHprek1qQTFOaTB5TURFM01EUXlOREl6TWpVeE16TXpOQzB4TlRNd01USTRORGMxTG5CdVp3PT0uanBn.jpg?w=700&webp=1)