简单数据库操作

 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