执行语句导入数据:
LOAD DATA INFILE 'e:\\load.txt'
INTO TABLE ms.tb_employee_info(id,name)
LINES TERMINATED BY '\n'
IGNORE 1 LINES;错误信息:
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 'LINES TERMINATED BY '\n'
IGNORE 1 LINES' at line 3去掉最后两行能正常运行,实在是看不出哪里有问题了……
LOAD DATA INFILE 'e:\\load.txt'
INTO TABLE ms.tb_employee_info(id,name)
LINES TERMINATED BY '\n'
IGNORE 1 LINES;错误信息:
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 'LINES TERMINATED BY '\n'
IGNORE 1 LINES' at line 3去掉最后两行能正常运行,实在是看不出哪里有问题了……
LOAD DATA INFILE 'e:\\load.txt'
INTO TABLE ms.tb_employee_info
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(id,name);附上正确语法:
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[CHARACTER SET charset_name]
[{FIELDS | COLUMNS}
[TERMINATED BY 'string']
[[OPTIONALLY] ENCLOSED BY 'char']
[ESCAPED BY 'char']
]
[LINES
[STARTING BY 'string']
[TERMINATED BY 'string']
]
[IGNORE number LINES]
[(col_name_or_user_var,...)]
[SET col_name = expr,...]谁来回个我结贴了饿