DB package... mysql: LOAD DATA LOCAL INFILE
| From: | Brian Anderson | 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