2

I wanted to upload a csv file using SQL commands but I got this error.

As a result of LOCAL INFILE command server wants to read yob2019.csv file, but as of v2.0 you must provide streamFactory option returning ReadStream.

I am working in VScode envoronment with mysql version 8.2.0.

Here is my sql

LOAD DATA LOCAL INFILE 'yob2019.csv' INTO TABLE baby_names FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

I have tried refrencing here but couldn't fix it.

Improve this question
Related questions
0
MySql Load data infile fields separated by cama splitting singe column data in to two fields due to cama presents in data
1
LOAD DATA LOCAL INFILE not working in RDS
0
different line break characters in CSVs
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.