MySQL with as 一直报错

前言

写临时表一直报错

[42000][1064] You have an error in your SQL syntax; check the manual that corresponds to your 
MySQL server version for the right syntax to use near 'A as (select som_code from sixs_organization_manage), B as (select som_cod' at line 1

 with A as (select som_code from sixs_organization_manage)
select * from A;

原因

MySQL版本不支持

查看版本

 select version();