mysql - 在 Mysql 中找不到文件错误以及如何将 txt 文件加载到表中

Question

我写了一个查询，将文件数据插入到一个表中，如下所示

LOAD DATA local INFILE 'C:\Documents and Settings\Administrator\Desktop\Merge.txt' 
INTO TABLE tblachmaster
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES; 

但这给我一个错误，因为

C:Documents and SettingsAdministratorDesktopMerge.txt not found can any one tell why

我在文件中的数据如下我想使用查询插入

101 111100022 5104885671104200936A094101CapitalOne                           MudiamInc        
5220MudiamInc                           A510488567CCDITServices000000110422   1111100020000001
622968765348545646565        00004000001007           rajeshk                 1111100020000001
62297877654775676546546      00002888891007           rajeshk                 1111100020000002
82200000020194754188000000000000000000688889A510488567                         111100020000001
5220MudiamInc                           A510488567CCDITServices000000110422   1111100020000002
62212345678034354465677      00000864451005           swethau                 1111100020000003
62212345678087664534543      00000559841011           swathiK                 1111100020000004
62212345678097867546435      00000579351012           lavanyaK                1111100020000005
6221234567806754654435435    00000846761013           AnithaN                 1111100020000006
82200000040049382712000000000000000000285040A510488567                         111100020000002
9000002000001000000060244136900000000000000000071739300                                       

Answer 1

会不会是错误的斜杠:\ 而不是 /？注意:\ 通常表示转义，如 \n。