无法创建/写入文件(错误代码:22) [英] Can't create/write to file (Errcode: 22)

问题描述

SQL的新功能，我想将一些数据从MySQL数据库导出到csv文件中.我在本地(本地主机)工作.

Quite new with SQL I'm looking to export some data from a MySQL database into a csv file. I'm working locally (localhost).

这是我的SQL语句:

SELECT DISTINCT *
INTO
OUTFILE 'C:\Users\Martin\Downloads\result.csv'
FROM provider, location, provider_has_location
WHERE 
provider.idprovider = provider_has_location.provider_idprovider AND
location.idLocation = provider_has_location.location_idLocation
LIMIT 20

MySQL返回以下错误:

MySQL return the following error:

无法创建/写入文件"C:UsersMartinDownloads esult.csv"(错误代码:22)

Can't create/write to file 'C:UsersMartinDownloads esult.csv' (Errcode: 22)

感谢您的帮助.

推荐答案

反斜杠可能会影响命令.尝试使用"\\"而不是"\".

It looks like the back-slashes may be affecting the command. Try using '\\' instead of '\'.

这篇关于无法创建/写入文件(错误代码:22)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！