I have a CSV file that i want to enter into a table in my database which is present on a remote server. But presently I don't have access to temp folder so I cannot copy my file on that folder. Is there a way I can upload file from any random folder onto the database?
This is my command in sql server:
load data local infile 'C:/Users/trainee_aiyer/Downloads/cash_ord.csv' into table cm_ord fields terminated by ',' enclosed by '"' lines terminated by '\n';
and my file path is this:
I switched '\' to '/' as the prior was causing syntax errors. but I get an error saying
ERROR 2 (HY000): File 'C:/Users/trainee_aiyer/cash_ord.csv' not found (Errcode: 2 "No such file or directory")