SQL建表--直接向表中写入数据

insert overwrite into #fdm_v03_tb_region_v
select '四川' as province, '川藏渝大区' as region union all
select '西藏' as province, '川藏渝大区' as region union all
select '重庆' as province, '川藏渝大区' as region union all
select '黑龙江' as province, '黑吉大区' as region union all
select '吉林' as province, '黑吉大区' as region union all
select '辽宁' as province, '辽蒙大区' as region union all
select '甘肃' as province, '甘青宁蒙大区' as region union all
select '内蒙古' as province, '甘青宁蒙大区' as region union all
select '宁夏' as province, '甘青宁蒙大区' as region union all
select '青海' as province, '甘青宁蒙大区' as region union all
select 'Alsace' as province, '海外' as region union all
select '澳门' as province, '海外' as region union all
select '江苏' as province, '沪苏大区' as region union all
select '上海' as province, '沪苏大区' as region union all
select '广东' as province, '华南大区' as region union all
select '海南' as province, '华南大区' as region union all
select '湖南' as province, '湘赣大区' as region union all
select '江西' as province, '湘赣大区' as region union all
select '安徽' as province, '华中大区' as region union all
select '湖北' as province, '华中大区' as region union all
select '北京' as province, '京津冀大区' as region union all
select '河北' as province, '京津冀大区' as region union all
select '天津' as province, '京津冀大区' as region union all
select '福建' as province, '闽浙大区' as region union all
select '浙江' as province, '闽浙大区' as region union all
select '山东' as province, '山东大区' as region union all
select '广西' as province, '西南大区' as region union all
select '贵州' as province, '西南大区' as region union all
select '云南' as province, '西南大区' as region union all
select '新疆' as province, '新疆大区' as region union all
select '河南' as province, '河南大区' as region union all
select '山西' as province, '陕晋大区' as region union all
select '陕西' as province, '陕晋大区' as region 
;

create table as ctemp1 as
select '23' as reg,'甘肃省' as from_name,'甘肃' as to_name union all
select '11' as reg,'山西省' as from_name,'山西' as to_name union all
select '32' as reg,'香港特别行政区' as from_name,'香港' as to_name union all
select '19' as reg,'浙江省' as from_name,'浙江' as to_name union all
select '25' as reg,'西藏自治区' as from_name,'西藏' as to_name union all
select '14' as reg,'新疆维吾尔自治区' as from_name,'新疆' as to_name union all
select '30' as reg,'青海省' as from_name,'青海' as to_name union all
select '9' as reg,'安徽省' as from_name,'安徽' as to_name union all
select '33' as reg,'澳门特别行政区' as from_name,'澳门' as to_name union all
select '20' as reg,'海南省' as from_name,'海南' as to_name union all
select '26' as reg,'贵州省' as from_name,'贵州' as to_name union all
select '13' as reg,'广西壮族自治区' as from_name,'广西' as to_name union all
select '1' as reg,'上海市' as from_name,'上海' as to_name union all
select '8' as reg,'宁夏回族自治区' as from_name,'宁夏' as to_name union all
select '21' as reg,'湖北省' as from_name,'湖北' as to_name union all
select '3' as reg,'内蒙古自治区' as from_name,'内蒙' as to_name union all
select '5' as reg,'吉林省' as from_name,'吉林' as to_name union all
select '31' as reg,'黑龙江省' as from_name,'黑龙江' as to_name union all
select '17' as reg,'河北省' as from_name,'河北' as to_name union all
select '27' as reg,'辽宁省' as from_name,'辽宁' as to_name union all
select '7' as reg,'天津市' as from_name,'天津' as to_name union all
select '28' as reg,'重庆市' as from_name,'重庆' as to_name union all
select '18' as reg,'河南省' as from_name,'河南' as to_name union all
select '4' as reg,'北京市' as from_name,'北京' as to_name union all
select '15' as reg,'江苏省' as from_name,'江苏' as to_name union all
select '2' as reg,'云南省' as from_name,'云南' as to_name union all
select '6' as reg,'四川省' as from_name,'四川' as to_name union all
select '22' as reg,'湖南省' as from_name,'湖南' as to_name union all
select '10' as reg,'山东省' as from_name,'山东' as to_name union all
select '24' as reg,'福建省' as from_name,'福建' as to_name union all
select '12' as reg,'广东省' as from_name,'广东' as to_name union all
select '29' as reg,'陕西省' as from_name,'陕西' as to_name union all
select '16' as reg,'江西省' as from_name,'江西' as to_name


insert overwrite into #dim_bsp_v03_province_name_map 
select * from ctemp1
;