*.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