1、with xxx as (select "a" as name，1 as age union all select "b",2)
生成一张叫xxx的临时表
| name | age |
| a | 1 |
| b | 2 |
2、with xxx as (select a字段 from b表),xxx2 as (select a2字段 from b2表)
生成两张临时表，一张叫xxx，一张叫xxx2
https://zhuanlan.zhihu.com/p/133539313
https://www.qycn.com/xzx/article/1437.html
标签：临时,xxx,生成,https,mysql,select From： https://www.cnblogs.com/hushuer/p/17329695.html