On 5/10/06 7:58, "Mark Galbreath" <[EMAIL PROTECTED]> wrote:
> Hi guys, > > The following query works fine from the MySQL client: > > LOAD DATA INFILE 'data.txt' INTO TABLE 'db.table' FIELDS TERMINATED BY '|' > > but fails in perl with a malformed SQL syntax error: > > my $rows = $dbh->do(LOAD DATA INFILE 'data.txt' INTO TABLE 'db.table' FIELDS > TERMINATED BY '|'); > > Anybody have a clue as to why this will not work? That hasn't the faintest hope of working. You should post the actual code that you're using. do() with a non-string argument is surely not your actual code. Also, 'db.table' doesn't look like a valid quoted identifier.
