[ale] perl:DBI

Jeremy T. Bouse undrgrid at undergrid.net
Mon Jun 22 16:36:20 EDT 1998


-----BEGIN PGP SIGNED MESSAGE-----

On Mon, 22 Jun 1998, Mir Shafiqul Islam wrote:

> Date: Mon, 22 Jun 1998 13:29:38 -0400 (EDT)
> From: Mir Shafiqul Islam <mir at oisp.gsu.edu>
> To: "Jeremy T. Bouse" <undrgrid at undergrid.net>
> Cc: ale <ale at cc.gatech.edu>
> Subject: Re: [ale] perl:DBI
> 
> Sorry, my post was vague. I can connect to mySQL server and run queries
> fine. But when I am inserting data, sometimes SQL server will return error
> because of duplicate key entires. It is normal in my case and I do not
> want those error message to clutter up my terminal or worse generate many
> mails while being run from cron. I hope it is clear now. Thanks.
> 
	This sounds to me like you have some fields set as PRIMARY or
UNIQUE keys... in which case MySQL will always and forever complain when
it gets a duplicate entry... easiest way to tell this is to do a DESCRIBE
on the table or do a mysqldump and view the design of each table... 
	Sincerely,
	Jeremy T. Bouse
	System Administrator

    Jeremy T. Bouse - SouthNet TeleComm Services, Inc - www.STSI.net
  PGP ID/Fingerprint: 1024/E83D9AE5/4ACC03F098D78198  19D0593E50E597E9
 Public PGP key available by sending email with 'send pgpkey' in subject
     undrgrid at UnderGrid.net - NIC Whois: JB5713 - undrgrid at STSI.net
          /earth is 98% full ... please delete anyone you can.


-----BEGIN PGP SIGNATURE-----
Version: 2.6.3a
Charset: noconv

iQCVAwUBNY7ASOak13roPZrlAQGnrwP+NsN/oNYqSEJHo0tEPP7B83BZZVCbTz0P
FlrORPESNtVkV7h6esYDPFuC991Cu/FsXPFao4ImRfDZOHXbzSFB2nNf+Jt+Jeq4
EFcKxt8pjoMv61Ik/KejzR0rVAWloL7B6ZVWBqMwGdb5+KAcAbwez/GJ6tD7+7fU
8rEKErM3i5Q=
=pNrn
-----END PGP SIGNATURE-----






More information about the Ale mailing list