List:General Discussion« Previous MessageNext Message »
From:Olaf Stein Date:March 2 2010 4:49pm
Subject:Re: redirecting query output?
View as plain text  
I don't think you do anything about the output, you could however check if a record is
already in the table before inserting it... And skip it if already there

Olaf


On 3/2/10 11:17 AM, "Richard Reina" <richard@stripped> wrote:

I have a perl script that periodically reads and enters (via perl->DBI parsed system
output (about received faxes) into a table.  Since the old output is repeated I have put,
when creating the table, the UNIQUE key on the field of the faxname, which is always
different (something like fax000007879.tif)

Every time the script is run many of the old faxes that have already been entered into
the table are still on the server (as I would like them to be).  As a result MySQL via
execute() dutifully warns about all the duplicate errors. Is there anyway to redirect
that output so the it does not appear as standard output? Or is it a bad idea to do so
and should I being doing a different sort ow query altogether?

Thanks,

Richard

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1







-------------------------
Olaf Stein
DBA
Battelle Center for Mathematical Medicine
Nationwide Children's Hospital, The Research Institute
700 Children's Drive
43205 Columbus, OH
phone: 1-614-355-5685
cell: 1-614-843-0432
email: olaf.stein@stripped


"I consider that the golden rule requires that if I like a program I must share it with
other people who like it."
Richard M. Stallman



Thread
redirecting query output?Richard Reina2 Mar
  • Re: redirecting query output?Olaf Stein2 Mar
  • Re: redirecting query output?Chris W2 Mar