Error executing: Query was empty

[andrewxie]

expert,
I run a perl script on solaris9.
this is the script:
my $sql = "SELECT produce_code, product_name INTO OUTFILE 'export.txt' from products";
my $sth = $dbh->prepare($sth);
$sth->execute or die("Error executing:$DBI::errstr");

it returns error excuting: Query was empty at line 222.
when I run it at mysql>SELECT produce_code, product_name INTO OUTFILE 'export.txt' from products;
it returns records.

anybody can tell me what's wrong?

 

[azzazzello]

you are not doing 'use strict' are you! BAD Andrew!

look at this line
my $sth = $dbh->prepare($sth);

I think you meant to write
my $sth = $dbh->prepare($sql);

ALWAYS USE STRICT!! And it won't let you shoot yourself in the foot by doing this

 

[andrewxie]

thank you for your reply. but nothgin wrong with
my $sth = $dbh->prepare($sth); I used USE strict; the sytax is correct.

 

[azzazzello]

my $sql = "SELECT produce_code, product_name INTO OUTFILE 'export.txt' from products";
my $sth = $dbh->prepare($sth);
/|\
|
|

you are preparing $sth. You should be preparing $sql.

 

[andrewxie]

thank you.