i磎 trying with no success the following command in MySql. Get error 2 "file not find". "myfile.txt" is on my PC and "mytable" is on server host. Anyone can help?
LOAD DATA LOCAL INFILE 'c:/myfile.txt' INTO TABLE mytable FIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\n'
LOAD DATA LOCAL INFILE 'c:/myfile.txt' INTO TABLE mytable FIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\n'