can磘 load TXT File into table

admin

Administrator
Staff member
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'
 
Back
Top