mysql union 字段顺序 必须一致
union字段顺序必须一致,否则后面的字段名会失效,都会以第一个顺序为准
1 | SELECT 1 AS a , 11 AS b UNION SELECT 2 AS b, 22 AS a |
| a | b |
|---|---|
| 1 | 11 |
| — | — |
| 2 | 22 |
本博客所有文章除特别声明外，均采用 CC BY-NC-SA 4.0 许可协议。转载请注明来源 Dev！
union字段顺序必须一致,否则后面的字段名会失效,都会以第一个顺序为准
1 | SELECT 1 AS a , 11 AS b UNION SELECT 2 AS b, 22 AS a |
| a | b |
|---|---|
| 1 | 11 |
| — | — |
| 2 | 22 |
