mysql导入邮件

邮件数据导入

delete from subscriptions

LOAD DATA INFILE '/tmp/alluses.txt'

INTO TABLE subscriptions

FIELDS TERMINATED BY ','

ENCLOSED BY '"'

ESCAPED BY '\\'

LINES TERMINATED BY '\n'

(`email`)

select count(*) from subscriptions

select * from subscriptions where email like "%vancl%"

select * from subscriptions where email not like "%@%"邮件数据导入

delete from subscriptions

LOAD DATA INFILE '/tmp/allusernames.txt'

INTO TABLE subscriptions

FIELDS TERMINATED BY ','

ENCLOSED BY '"'

ESCAPED BY '\\'

LINES TERMINATED BY '\n'

(`email`)

select count(*) from subscriptions

select * from subscriptions where email not like "%@%"