> docker exec -it craig bash > mysql -u root -p --local-infile > use craigslist; > > LOAD DATA LOCAL INFILE 'C:/Users/hank/Desktop/craigs/data.csv' > INTO TABLE books_mags > FIELDS TERMINATED BY ',' > LINES TERMINATED BY '\n' > IGNORE 1 ROWS;
I have a csv file on my desktop that I am looking to enter into a MySQL table. But i am having a rough time figuring out the file path errors.
ERROR 2 (HY000): File ‘C:/Users/hank/Desktop/craigs/data.csv’ not found (OS errno 2 – No such file or directory)
I keep getting this error.
I am using a windows 10 and a docker containter for mySQL.
How can I put my csv into MYSQL?