mysql导入邮件

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 "%@%"

posted on 2010-12-22 13:51  lexus 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/lexus/archive/2010/12/22/1913799.html