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:[EMAIL PROTECTED] > Sent: donderdag 17 juli 2003 17:12 > To: [EMAIL PROTECTED] > 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
