SQL对比记录

 

*.ctl 内容

load data
infile '***.txt'
append into table test1
fields terminated by X'09'
(testid)

 

SQL:

select a.* from zs_pt_zk7 a,zs_bank_zk7 b where a.jgdm=b.jgdm

select a.* from zs_pt_zk7 a where a.jgdm not in (select jgdm from zs_bank_zk7)

（修改后再执行一次）

查重
select jgdm,count(jgdm) from  zs_pt_zy
group by jgdm
having count(jgdm)>1

select count(*) from zs_pt_zk7

 

 

MySQL 导出数据： 进入bin目录 mysqldump -u <username> -p <password> <sid>  > xxx.sql