Can't create/write to file (Errcode: 22)
11,476
It looks like the back-slashes may be affecting the command. Try using '\\' instead of '\'.
Author by
magdmartin
business / data oriented person. I'm not a dev. or a sys admin but I don't mind getting my hand dirty when needed. OpenRefine fan!
Updated on June 04, 2022Comments
-
magdmartin about 2 years
Quite new with SQL I'm looking to export some data from a MySQL database into a csv file. I'm working locally (localhost).
Here is my SQL statement:
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 return the following error:
Can't create/write to file 'C:UsersMartinDownloads esult.csv' (Errcode: 22)
Thanks for your help.