Re: Load Data Infile Local

[Gerald Clark]

Jayme Jeffman Filho wrote:

> I am trying to use the the command below through a HTML/PHP3 interface.
> I need to include several registers into some tables and I'd like not have
> to use INSERT. I tried every combination of upper and lower case in tha
> query, but the error is everytime the same The steps I'm doing are:
> 1. Define the query text $query = "LOAD DATA LOCAL INFILE "C:\\PROD.TXT"
> INTO TABLE Product";

Use the $dbh->quote() function to quote your string, or change one of the quotes.

Ex:

$query = 'LOAD DATA LOCAL INFILE "C:\\PROD.TXT"  INTO TABLE Product' ;