mysql 用 load data infile 把CSV文件到如到表里

mysql>load data infile '/tmp/UserEmail .csv'
into table user_info1_shinnseityuu
fields terminated by ',' optionally enclosed by '"' escaped by '"'
lines terminated by '\r\n';

文件中有中文字符的话，可能的指点编码

mysql>load data infile '/tmp/UserEmail .csv'
into table user_info1_shinnseityuu character set gb2312  --包含控制导入后字符的正确语句
fields terminated by ',' optionally enclosed by '"' escaped by '"'
lines terminated by '\r\n';