RE: Select via Perl

[Ashwin Kutty]

Thanks to everyone who replied.  I have been able to clean up the code and
it works fine now.

Thanks again.

On Fri, 18 Jul 2003, Rudy Metzger wrote:

> 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
>
>