RE: INSERT ... ON DUPLICATE KEY UPDATE seems so close and yet so far...

2007-04-30 Thread Daevid Vincent
-Original Message- From: Philip Hallstrom [mailto:[EMAIL PROTECTED] Because if you wanted that you'd use REPLACE which is mysql specific which is okay since it's mysql you're using I guess. Except for the CRITICAL issue that REPLACE will DELETE the row first, thereby causing all

Re: INSERT ... ON DUPLICATE KEY UPDATE seems so close and yet so far...

2007-04-27 Thread Philip Hallstrom
Maybe this is some SQL standard implementation and that's why it is what it is, but to me it seems completely retarded that you have to explicitly call out the columns... http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html Why doesn't it work in a more convenient and sane way?! So