OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: [MySQL] Re: REPOST: ON DUPLICATE failure

From: Ashley M. Kirchner (ashleypcraft.com)
Date: Wed Jan 21 2009 - 22:44:22 CST


Michael Dykman wrote:
> It
> worked fine as you wrote it on my v5.0.45, although it reported 2 rows
> affected on each subsequent run of the insert statement. I thought
> this odd as I only ran the same statement repeatedly leaving me with
> one row ever, but the value updated just fine.
>
    I noticed that too. It reports 2 rows, but there's only 1. That
was my first indication that something's awry. But then when I tried it
on 5.1.30, it did the same thing, 2 rows. But at least it DID update on
5.1.30, but not on 5.0.37.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql