Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: Urgent help !!!!

by jZed (Prior)
on Oct 17, 2007 at 19:58 UTC ( [id://645575]=note: print w/replies, xml ) Need Help??


in reply to Urgent help !!!!

> my $sql = "SELECT * INTO OUTFILE 'g:/dbf2csv/$filename'
> FIELDS TERMINATED BY ','
> LINES TERMINATED BY '\r\n' FROM reg501";

That syntax is specific to MySQL and won't work with DBD::CSV. You can accomplish the same thing like this:

$dbh->{csv_files}->{outfile} = { file => "g:/dbf2csv/$filename", sep_char => ',', eol => '\r\n' }; $dbh->do(" CREATE TABLE outfile AS SELECT * FROM sourceTable ");

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://645575]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (4)
As of 2024-04-23 04:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found