csv文件导入到mysql

先创建表   然后执行sql命令

load data infile 'D:\\phpStudy\\MySQL\\bin\\info_526.csv'
into table `practice`.`info_c`
fields ESCAPED by '\\'
TERMINATED by ','
ENCLOSED by '"'
LINES TERMINATED by '\r\n'
(`id`,`ns`,`company`,`name`,`origin`,`package`,`desc`,`num`,`net`,`net_num`,`net`,`net_b`,`net_c`,`net_d`);