DB package... mysql: LOAD DATA LOCAL INFILE

From: Date: Mon, 07 Mar 2005 21:43:49 +0000
Subject: DB package... mysql: LOAD DATA LOCAL INFILE
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-17913@lists.php.net to get a copy of this message
First, thanks to all PEAR developers! I am looking for a way to successfully execute the following SQL via the pear DB package: LOAD DATA INFILE 'tmp/myfile.csv' INTO TABLE my_table FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' The DB packages converts this (escapes the quotes and slashes) to this: LOAD DATA INFILE "tmp/myfile.csv" INTO TABLE my_table FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY \'"\' ESCAPED BY "\\" LINES TERMINATED BY "\\r\\n" Is there a way to use the DB object with out having it touch the query I put in the $db->query()? Thanks for the help, Brian Anderson

« previous php.pear.general (#17913) next »