Re: Select via Perl

[gerald_clark]

Ashwin Kutty wrote:

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? 

Yes

Is there any other
way I can dump the results of the select to a file of some sort?
Have the perl program append the /tmp/result.txt to 
/tmp/ultimateresult.txt , and unlink /tmp/result.txt
inside your loop.

Thanks..

 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]