I have installed MySQL database on EC2 instance.I am very new to database area.
I used faker and generate fake data on my local computer called sales.csv.
I created a database called sales
I chose the database sales
I created a table called sales with 2 columns
I used the command line
load data local infile 'C:/Users/sansan/sales.csv' fields terminated by ','
I got the error that the file cannot be found or the syntax for fields terminated by is not right.
I tried many things like changing / to \ and copied pasted the path, put in IP address... nothing works. I looked up the fields terminated by syntax. I do not see any errors there either.
Your help is greatly appreciated.