ERROR 29 (HY000): File 'D:\ est.csv' not found (Errcode: 2 - No such file or directory)
I got this error while executing below command in mysql
LOAD DATA INFILE 'D:\test.csv'
INTO TABLE emp
COLUMNS TERMINATED BY ';'
LINES TERMINATED BY '\r\n';
Problem : Path is not correctly define after INFILE
Solution : Use forward slash instead backward slash.
LOAD DATA INFILE 'D:/test.csv'
INTO TABLE emp
COLUMNS TERMINATED BY ';'
LINES TERMINATED BY '\r\n';
I got this error while executing below command in mysql
LOAD DATA INFILE 'D:\test.csv'
INTO TABLE emp
COLUMNS TERMINATED BY ';'
LINES TERMINATED BY '\r\n';
Problem : Path is not correctly define after INFILE
Solution : Use forward slash instead backward slash.
LOAD DATA INFILE 'D:/test.csv'
INTO TABLE emp
COLUMNS TERMINATED BY ';'
LINES TERMINATED BY '\r\n';
tks tks tks !!!
ReplyDeleteTHANK U SO MUCH
ReplyDelete