RE: update? insert? Perl script

[Paul DuBois]

At 4:55 PM -0400 8/24/99, Dan Ray wrote:
>Paul wrote:
>> if (defined ($yes)) # row exists
>> {
>> 	update
>> }
>> else                # row does not exist
>> {
>> 	insert
>> }
>
>I believe I may have stumbed across a better strategy than this. Anybody got
>any reason this wouldn't work?
>
>update
>get rows affected
>if (! rows affected) {
>	insert
>}
>
>In otherwords, just updating blindly, checking for effects, and inserting
>based on that. It's one fewer queries, certainly. Any downside to this?

If you happen to update to the same value, the row won't be considered
"affected" by MySQL and the row count will be zero.  Then you'll insert
another row.

-- 
Paul DuBois, paul@stripped