MySQL导出数据到txt
SELECT email FROM xxxxxx where email is not null and email <> '' into outfile '/mail.txt' lines terminated by '\r\n' ;
其中lines terminated by “\r\n”表示每一行(即每一条记录)用\r\n分隔,\r\n是window系
统的换行符;
FIELDS TERMINATED BY ',' --字段用,进行分隔
A表中的内容不在表中
select
name
from
A
where
name
not
in
(
select
name
from
B)