/**************’D:\BOOK.csv用写字板打开为,可以发现以“,”换字段,"\n"换行********************************/

0,AAA,aaa,100
1,BBB,bbb,200
2,CCC,ccc,300

导入到mysql的sql语句为:

LOAD DATA LOCAL INFILE ‘D:\\BOOK.csv’ INTO TABLE `book` FIELDS TERMINATED BY ‘,’ ESCAPED BY ‘\\’ LINES TERMINATED BY ‘\n';