mysql with as 公用表表示式（CTE）

1. 例子

 with A as (select * from class)

    select *from A 

MySQL8.0 才支援