错误1064 LOAD DATA INFILE

Question

我想几千记录加载到从制表符分隔的文本文件，我的MySQL数据库，但我收到错误消息：

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 'FIELDS 
TERMINATED BY '\t' ENCLOSED BY '" ' 
LINES TERMINATED BY '\n'' at line 2 

我的命令是：

LOAD DATA INFILE 'records.txt' INTO TABLE records (vendor, title, id, part, project, 
description, machine, shelf, compartment, checkout) 
FIELDS TERMINATED BY '\t' ENCLOSED BY '"' 
LINES TERMINATED BY '\n'; 

我试过了不同的选项，比如'''，'LINES TERMINATED BY'\ r \ n'，并且在ENCLOSED BY'''中的引号后加了一个空格，但我仍然收到错误信息以上。

我哪里错了？

Answer 1

我不是很习惯这个命令，但我要说的是正确的查询是：

LOAD DATA INFILE 'records.txt' INTO TABLE records 
FIELDS TERMINATED BY '\t' ENCLOSED BY '"' 
LINES TERMINATED BY '\n' (vendor, title, id, part, project, 
description, machine, shelf, compartment, checkout);