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? tia, mark
- DBI Issue with MySQL query Mark Galbreath
- Re: DBI Issue with MySQL query Paul DuBois
- Re: DBI Issue with MySQL query Mark Galbreath
- Re: DBI Issue with MySQL query Tim Bunce
- Re: DBI Issue with MySQL query Mark Galbreath
- Re: DBI Issue with MySQL query Martin J. Evans
- Re: DBI Issue with MySQL query Paul DuBois
- Re: DBI Issue with MySQL query Paul DuBois
- Re: DBI Issue with MySQL query Mark Galbreath
- Re: DBI Issue with MySQL query Mark Galbreath
- Re: DBI Issue with MySQL query Paul DuBois