数据库查询结果创建表

mysql 查询结果创建表

create table table_name as select * from (sql) as sql_table;

table_name 替换成表名

sql 替换成sql语句

create table new_table_name as select * from
(
select '浙江省' as sheng,'' as shi,'' as xian,SUBSTRING(qxdm,1,2) as code,
ROUND(dqszzz,2) as n2019
from zs_sjyqfx_2019_ads GROUP BY code
union
select '浙江省' as sheng,cs as shi,'' as xian,SUBSTRING(qxdm,1,4) as code,
ROUND(dqszzz,2) as n2019
from zs_sjyqfx_2019_ads group by code
union
select '浙江省' as sheng,cs as shi,qx as xian,qxdm as code,
ROUND(dqszzz,2) as n2019
from zs_sjyqfx_2019_ads group by qxdm,cs,qx
)
as sql_table