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]

Reply via email to