Question

mysql导入txt文件出错

执行语句是这段LOAD DATA LOCAL INFILE 'D:/nt.txt' INTO TABLE dede_archives LINES TERMINATED BY '\r\n' (title);
这里是出错消息： 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 'LOAD DATA LOCAL INFILE 'D:/nt.txt' INTO TABLE dede_archives LINES TERMINATED BY ' at line 1

Answer 1

LOAD DATA LOCAL INFILE 'D:/nt.txt'
改为
LOAD DATA LOCAL INFILE 'D:\nt.txt'
试试

追问

不行，提示一样的问题

追答

LOAD DATA LOCAL INFILE 'd:/nt.txt' INTO TABLE dede_archives terminated BY '\r\n';
这样试试可不可以呀

Answer 2

is your infile can be accessed through 'd:/nt.txt'?

try to add database name in front of your table.

Answer 3

路径需不需要加两个斜杠来转义啊？ 额 好久在没windows下用mysql了