The reporting of two rows thing is to do with how MySQL handles INSERT ... ON DUPLICATE KEY UPDATE ... statements; it will report 1 row if it inserts, and 2 rows if it finds a duplicate key and has to update as well.
http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html Just after the first code box. On Wed, 2009-01-21 at 21:44 -0700, Ashley M. Kirchner wrote: > 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. > -- Ian Simpson System Administrator MyJobGroup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
