/**************’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';