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" <rich...@rushlogistics.com> 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=olaf.st...@nationwidechildrens.org ------------------------- 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.st...@nationwidechildrens.org "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
