mysql导入csv文件

load data infile '/xampp/cp.csv' 
into table infotest  character set utf8 
fields terminated by ','  optionally enclosed by '"' escaped by '"' 

lines terminated by '\r\n'; 

参考：http://my.oschina.net/startphp/blog/135535