I have a CSV file which I want to import into my database. I tried to just use import, it failed, when I went searching it appears as if SQL files are the only ones you can import using that feature. So I opened up the SQL Command to try an Load the file: I tried
LOAD DATA LOCAL INFILE ‘c:\Users\Trent\Documents\RV\SouthCamp.csv’
INTO TABLE Campgrounds
FIELDS TERMINATED BY ‘,’
ENCLOSED BY ‘"’
LINES TERMINATED BY ‘\n’;
But i am told the file is not found. How might I upload this file of mine? If it is not already apparent, I am new.