1、合并两张表,有共同的字段zipcode,text_008的数据比text_0的多.
create table atext110
as
select text_008.zipcode,num0,num1 from text_008 left join text_0 on text_008.zipcode = text_0.zipcode
2、zengliang相同的合并到一块,统计zengliang相同的zengliang个数
create table atext200
as
select count(zengliang) ,zengliang from atext111 group by zengliang
3、把从hebing0_1查询出的数据插入到hebing0_1_2中
insert into hebing0_1_2 select * from hebing0_1
4、查询shitu0的数据总数
select count(*)from shitu0
5、删除atext0_1中的重复字段(整行重复)
create view atext_01
as
select distinct * from atext0_1 order by zipcode
6、查询没有重复的所有zipcode
create view shitu0(zipcode)
as
select zipcode
from record
group by zipcode
7、把所有不在hebing0_1中的zipcode插入到hebing0_1
insert into hebing0_1 select * from shitu0 where zipcode not in(select zipcode from hebing0_1)
8、把shitu0中的zipcode字段插入到新建的表hebingshitu0中
create table hebingshitu0(zipcode)
as
select zipcode from shitu0