将数据加载到文件MySQL MacOS中 [英] Load Data In file MySQL MacOS

问题描述

我正在尝试使用MySQL从CSV加载数据，但是却收到错误代码29(找不到文件).我使用的是Mac osx，但是当我运行以下查询

I'm trying to load data from a CSV using MySQL, but I'm getting Error code 29 (file not found). I'm using mac osx, but when I run the following query

LOAD DATA INFILE '/workspace/SQL_Test/src/values.csv' 
INTO TABLE queryid_vs_column
COLUMNS TERMINATED BY ','

MySQL尝试查找"C:/workspace/SQL_Test/src/values.csv".我没有找到其他人遇到类似的问题，有人遇到过类似的问题吗?我不确定MySQL为什么认为我正在运行Windows计算机.

MySQL tries to look in 'C:/workspace/SQL_Test/src/values.csv'. I haven't found anyone else with similar issues, has anyone encountered something like this? I'm not sure why MySQL thinks I'm running a windows machine.

谢谢.

推荐答案

如果不使用LOCAL修饰符，它将访问服务器上的文件.将查询更改为:

If you don't use the LOCAL modifier, it accesses the file on the server. Change your query to:

LOAD DATA LOCAL INFILE '/workspace/SQL_Test/src/values.csv' 
INTO TABLE queryid_vs_column
COLUMNS TERMINATED BY ','

这篇关于将数据加载到文件MySQL MacOS中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！