RE: INSERT [IGNORE] INTO TABLE

>Not a good feature for me.

Me neither, but...

>Check existence and then insert or update.

At least once a week I seem to be responding to this exact same suggestion.  Somebody _please_ tell me if I'm the only
onein the whole world who worries about race conditions?  What's wrong with just making sure there's a proper unique
key,and then just inserting the row?  The returned error message will tell you if a failure is due to duplicate key,
missingnon-null column, or an actual disaster.
 



Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com