Mysql 连接（left join, right join, inner join ,full join）
select * from class1leftjoin class2 on class1.id=class2.idUNION select * from class1rightjoin class2 on class1.id=class2.id;
id | name | class| id | name | class |
+------+--------+--------+------+--------+-------+
| 17 | linux| 66 | 17 | linux| 66 |
| 18 | python | 23 | 18 | python | 23 |
| 19 | linux| 66 | 19 | linux| 66 |
| 20 | python | 23 | 20 | python | 23 |
| 21 | linux| 66 | 21 | linux| 66 |
| 22 | python | 23 | 22 | python | 23 |
| 23 | linux| 66 | 23 | linux| 66 |
| 24 | python | 23 | 24 | python | 23 |
| 25 | linux| 66 | 25 | linux| 66 |
| 26 | python | 23 | 26 | python | 23 |
| 27 | linux| 66 | 27 | linux| 66 |
| 28 | python | 23 | 28 | python | 23 |
| 29 | linux| 66 | 29 | linux| 66 |
| 30 | python | 23 | 30 | python | 23 |
| 31 | linux| 66 | 31 | | |
| 32 | python | 23 | 32 | | |
| 33 | linux| 66 | 33 | | |
| 34 | python | 23 | 34 | | |
| 35 | linux| 66 | 35 | | |
| 36 | python | 23 | 36 | | |
| 37 | linux| 66 | 37 | | |
| 38 | python | 23 | 38 | | |
| 39 | linux| 66 | 39 | | |
| 40 | python | 23 | 40 | | |
| 41 | linux| 66 | 41 | | |
| 42 | python | 23 | 42 | | |
| 43 | linux| 66 | 43 | | |
| 44 | python | 23 | 44 | | |
| 45 | linux| 66 | 45 | | |
| 46 | python | 23 | 46 | | |
| 47 | linux| 66 | 47 | | |
| 48 | python | 23 | 48 | | |
| 49 | linux| 66 | 49 | | |
| 50 | python | 23 | 50 | | |
| 51 | linux| 66 | 51 | | |
| 52 | python | 23 | 52 | | |
| 53 | linux| 66 | 53 | | |
| 54 | python | 23 | 54 | | |
| 55 | linux| 66 | 55 | | |
| 56 | python | 23 | 56 | | |
| 57 | linux| 66 | 57 | | |
| 58 | python | 23 | 58 | | |
| 59 | linux| 66 | 59 | | |
| 60 | python | 23 | 60 | | |
| 61 | linux| 66 | 61 | | |
| 62 | python | 23 | 62 | | |
| 63 | linux| 66 | 63 | | |
| 64 | python | 23 | 64 | | |
| 65 | linux| 66 | 65 | | |
| 66 | python | 23 | 66 | | |
| 67 | linux| 66 | 67 | | |
| 68 | python | 23 | 68 | | |
| 69 | linux| 66 | 69 | | |
| 70 | python | 23 | 70 | | |
| 71 | linux| 66 | 71 | | |
| 72 | python | 23 | 72 | | |
| 73 | linux| 66 | 73 | | |
| 74 | python | 23 | 74 | | |
| 75 | linux| 66 | 75 | | |
| 76 | python | 23 | 76 | | |
| 77 | linux| 66 | 77 | | |
| 78 | python | 23 | 78 | | |
| 79 | linux| 66 | 79 | | |
| 80 | python | 23 | 80 | | |
| 81 | linux| 66 | 81 | | |
| 82 | python | 23 | 82 | | |
| 83 | linux| 66 | 83 | | |
| 84 | python | 23 | 84 | | |
| 85 | linux| 66 | 85 | | |
| 86 | python | 23 | 86 | | |
| 87 | linux| 66 | 87 | | |
| 88 | python | 23 | 88 | | |
| 89 | linux| 66 | 89 | | |
| 90 | python | 23 | 90 | | |
| 91 | linux| 66 | 91 | | |
| 92 | python | 23 | 92 | | |
| 93 | linux| 66 | 93 | | |
| 94 | python | 23 | 94 | | |
| 95 | Tom | 1year| 95 | | |
| 96 | Jack | 2year| 96 | | |
| 97 | Yaheng | winner | 97 | | |
| 98 | Tom | 1year| 98 | | |
| 99 | Jack | 2year| 99 | | |
|100 | Yaheng | winner |100 | | |
|101 | Tom | 1year|101 | | |
|102 | Jack | 2year|102 | | |
|103 | Yaheng | winner |103 | | |
|104 | Tom | 1year|104 | | |
|105 | Jack | 2year|105 | | |
|106 | Yaheng | winner |106 | | |
|107 | Tom | 1year|107 | | |
|108 | Jack | 2year|108 | | |
|109 | Yaheng | winner |109 | | |
|110 | Tom | 1year|110 | | |
|111 | Jack | 2year|111 | | |
|112 | Yaheng | winner |112 | | |
|113 | Tom | 1year|113 | | |
|114 | Jack | 2year|114 | | |
|115 | Yaheng | winner |115 | | |
|116 | Tom | 1year|116 | | |
|117 | Jack | 2year|117 | | |
|118 | Yaheng | winner |118 | | |
|119 | Tom | 1year|119 | | |
|120 | Jack | 2year|120 | | |
|121 | Yaheng | winner |121 | | |
|122 | Tom | 1year|122 | | |
|123 | Jack | 2year|123 | | |
|124 | Yaheng | winner |124 | | |
|125 | Tom | 1year|125 | | |
|126 | Jack | 2year|126 | | |
|127 | Yaheng | winner |127 | | |
|128 | Tom | 1year|128 | | |
|129 | Jack | 2year|129 | | |
|130 | Yaheng | winner |130 | | |
| NULL | NULL | NULL |131 | | |
| NULL | NULL | NULL |132 | | |
| NULL | NULL | NULL |133 | | |
| NULL | NULL | NULL |134 | | |
| NULL | NULL | NULL |135 | | |
| NULL | NULL | NULL |136 | | |
| NULL | NULL | NULL |137 | | |
| NULL | NULL | NULL |138 | | |
| NULL | NULL | NULL |139 | | |
| NULL | NULL | NULL |140 | | |
| NULL | NULL | NULL |141 | | |
| NULL | NULL | NULL |142 | | |
| NULL | NULL | NULL |143 | | |
| NULL | NULL | NULL |144 | | |
| NULL | NULL | NULL |145 | | |
| NULL | NULL | NULL |146 | | |
| NULL | NULL | NULL |147 | | |
| NULL | NULL | NULL |148 | | |
| NULL | NULL | NULL |149 | | |
| NULL | NULL | NULL |150 | | |
| NULL | NULL | NULL |151 | | |
| NULL | NULL | NULL |152 | | |
| NULL | NULL | NULL |153 | | |
| NULL | NULL | NULL |154 | | |
| NULL | NULL | NULL |155 | | |
| NULL | NULL | NULL |156 | | |
| NULL | NULL | NULL |157 | | |
| NULL | NULL | NULL |158 | | |
| NULL | NULL | NULL |159 | | |
| NULL | NULL | NULL |160 | | |
| NULL | NULL | NULL |161 | | |
| NULL | NULL | NULL |162 | | |
| NULL | NULL | NULL |163 | | |
| NULL | NULL | NULL |164 | | |
| NULL | NULL | NULL |165 | | |
| NULL | NULL | NULL |166 | | |
| NULL | NULL | NULL |167 | | |
| NULL | NULL | NULL |168 | | |
| NULL | NULL | NULL |169 | | |
| NULL | NULL | NULL |170 | | |
| NULL | NULL | NULL |171 | | |
| NULL | NULL | NULL |172 | | |
| NULL | NULL | NULL |173 | | |
| NULL | NULL | NULL |174 | | |
| NULL | NULL | NULL |175 | | |
| NULL | NULL | NULL |176 | | |
| NULL | NULL | NULL |177 | | |
| NULL | NULL | NULL |178 | | |
| NULL | NULL | NULL |179 | | |
| NULL | NULL | NULL |180 | | |
| NULL | NULL | NULL |181 | | |
| NULL | NULL | NULL |182 | | |
| NULL | NULL | NULL |183 | | |
| NULL | NULL | NULL |184 | | |
| NULL | NULL | NULL |185 | | |
| NULL | NULL | NULL |186 | | |
| NULL | NULL | NULL |187 | | |
| NULL | NULL | NULL |188 | | |
| NULL | NULL | NULL |189 | | |
| NULL | NULL | NULL |190 | | |
| NULL | NULL | NULL |191 | | |
| NULL | NULL | NULL |192 | | |
| NULL | NULL | NULL |193 | | |
| NULL | NULL | NULL |194 | | |
| NULL | NULL | NULL |195 | | |
| NULL | NULL | NULL |196 | | |
| NULL | NULL | NULL |197 | | |
| NULL | NULL | NULL |198 | | |
| NULL | NULL | NULL |199 | | |
| NULL | NULL | NULL |200 | | |
| NULL | NULL | NULL |201 | | |
| NULL | NULL | NULL |202 | | |
| NULL | NULL | NULL |203 | | |
| NULL | NULL | NULL |204 | | |
| NULL | NULL | NULL |205 | |
页:
[1]