把.csv文件导入mysql是产生错误

[无-]

想把.csv文件导入到mysql中，但是总是产生错误，错误的具体形式是：
mysql> load data infile '/home/peng/80train.csv'
-> into table 'train'
-> fields terminated by ',' optionally enclosed by '"' escaped by '"'
-> lines terminated by '\n';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''train'
fields terminated by ',' optionally enclosed by '"' escaped by '"'
lines' at line 2

我的csv数据格式是
196,242,3,881250949
186,302,3,891717742
62,257,2,879372434
200,222,5,876042340
194,274,2,879539794
119,392,4,886176814
308,1,4,887736532
63,277,4,875747401
160,234,5,876861185
225,193,4,879539727
求各位大师帮帮忙解答一下把

[ACMAIN_CHM]

into table 'train' 画蛇添足了，不需要加这个单引号' 直接改为 load data infile '/home/peng/80train.csv' into table train fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\n';

[无-]

这个试过，没有用。。

[rucypli]

mysql> load data infile '/home/backup/mysql/test.txt' into table test5 fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\n'; Query OK, 10 rows affected (0.01 sec) Records: 10 Deleted: 0 Skipped: 0 Warnings: 0

[ACMAIN_CHM]

引用 2 楼 u010657883 的回复:

这个试过，没有用。。

把错误信息贴出以供分析。

[无-]

引用 4 楼 ACMAIN_CHM 的回复:

引用 2 楼 u010657883 的回复:

这个试过，没有用。。

把错误信息贴出以供分析。

错误信息也是上面那个一样的

[欢乐的尼美]

LOAD DATA INFILE 'E:/123.csv' INTO TABLE user FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'