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

查看更多关于mysql导入邮件的详细内容...

声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://haodehen.cn/did43442