"This command is not supported in the prepared statement protocol yet".
When I tried to use "load data infile" as a raw query on a table , It failed with this error , and after playing with many parameters in the query and tried many DB methods like DB::raw,DB::statement and DB::select, but nothing change the problem still exist .
finally I can run the query but only the first raw was inserted,so The problem is in the query itself and Mysql server cannot under the end of line symbol , Just adding double back slash will solve this issue.
"LOAD DATA LOCAL INFILE 'filename' INTO TABLE `tablename` FIELDS TERMINATED BY ',' LINES TERMINATED BY '\\n' (col1,col2,col3)";
No comments:
Post a Comment