mysql加载程序错误?找不到'C:test.txt'(错误代码:2) [英] mysql loader error? 'C:test.txt' not found (Errcode: 2)

问题描述

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

I tried the following code to load data from text document (file name is test.txt) to MySQL database, but it shows an error:

找不到文件"C:test.txt"(错误代码:2)

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';

推荐答案

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

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

INTO TABLE 'messagebox'

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

这篇关于mysql加载程序错误?找不到'C:test.txt'(错误代码:2)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！