//指定数据库
use ginkgo;
//将数据导出到test1.xls
select fromAddr from emailinfo into outfile'F://test1.xls'
fieldsterminated by ',' optionally enclosed by '"' escaped by '"'
lines terminatedby '\r\n';
//创建新的表
create table f3(
fromAddrvarchar(150) primary key
);
//将导出的数据导入到新表中,这个地方因为设置了主键,所以导入的过程中重复数据不能被导入
LOAD DATA INFILE 'F://test1.xls'
REPLACE INTO TABLE f3
CHARACTER SET GBK
FIELDS TERMINATED BY "," ENCLOSED BY""
LINES TERMINATED BY "\r\n";
//查询不重复数据的行数
Select count(*)from ginkgo.f3;