mysql——with xxx as生成临时表

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