mysql导入文件

1、load local data infile "/var/tmp/ip.txt" into table `tableName` fields` terminated by ',' lines terminated by '\r\n';