uploading text files into SID
Hello. I'm getting started with a SQL data analysis book and they have text files that they want me to upload into a database (I decided to use SID and MySQL). The book gives me code to upload the text into mysql but I'm getting the error below.
Warning: PDOStatement::execute(): LOAD DATA LOCAL INFILE forbidden in /Applications/XAMPP/xamppfiles/htdocs/sid/sid.php on line 259
This is the code that looks for the files. Maybe I have the address of the folder wrong (I have a mac computer)
LOAD DATA
LOCAL INFILE '/Users/alexmartino/Desktoptextfiles/campaign.txt'
INTO TABLE campaign
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES
Subject
Written By
Posted
uploading text files into SID
August 29, 2015 03:54PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.