mysql 加载器错误？ 'C:test.txt' 未找到(错误代码 : 2)

Question

我尝试使用以下代码将文本文档(文件名为test.txt)中的数据加载到MySQL数据库，但显示错误:

File 'C:test.txt' not found (Errcode: 2)

查询是:

LOAD DATA LOCAL INFILE 'C:test.txt' INTO TABLE messagebox  fields terminated by ','  LINES TERMINATED BY '\n';

Answer 1

将您的驱动器地址修改为C:\\test.txt

LOAD DATA LOCAL INFILE 'C:\\test.txt' 

进入表“消息框”

fields terminated by ',' fields escaped by '\\' LINES TERMINATED BY '\n';