Receiving SQL Error [28]: (conn=72) error in DBeaver when trying to Load data infile command

user_15355629 0
Viewed 409

I am new to this, so kindly help me rectify my mistake here. I am trying to upload a csv file from my local DB into a table in my QA instance using Dbeaver and receiving the following error.

LOAD DATA LOCAL INFILE 'C:\Dirty_Node.csv' 
INTO TABLE dirty_node
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;

Error: SQL Error [28]: (conn=72) LOAD DATA LOCAL INFILE asked for file 'C:Dirty_Node.csv' that doesn't correspond to initial query LOAD DATA LOCAL INFILE 'C:\Dirty_Node.csv'

dbeaver import mysql
1 Answers

There are two possibuilities

First use / instead of \

LOAD DATA LOCAL INFILE 'C:/Dirty_Node.csv' 
INTO TABLE dirty_node
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;

OR ewsacpe the backslash with a second

LOAD DATA LOCAL INFILE 'C:\\Dirty_Node.csv' 
INTO TABLE dirty_node
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;
user_51935360
Related