mysql查询表中某列不重复的行数

//指定数据库

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;