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


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?



MySQL General Mailing List
For list archives:
To unsubscribe:

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

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