Can you please post the source code?
In any case, I would consider using DBI.
Cheers
/rudy
-----Original Message-----
From: Ashwin Kutty [mailto:akutty@stripped]
Sent: donderdag 17 juli 2003 17:12
To: mysql@stripped
Subject: Select via Perl
I am trying to read a file and see if the contents of it exists in the
DB
or not and am trying to do it via a Select.
I try to do a select * into outfile /tmp/result.txt from table where
field
like "%$var%"; but it always goes through the first two lines of the
input
file and then says the file already exists.
Is this because I read each line of a file in a for loop in perl and the
mysql query tries to recreate the outfile each time? Is there any other
way I can dump the results of the select to a file of some sort?
Thanks..
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
