前言
写临时表一直报错
[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();