List:General Discussion« Previous MessageNext Message »
From:wang shuming Date:April 20 2007 9:20am
Subject:Re: UPDATE and INSERT in one
View as plain text  
insert into table1 (fa,fb,qty) values (fa1,fb1,qty1) on duplicate key
update  qty=qty+qty1
a primarykey or unique key must.

Shuming　Wang
Thread
• UPDATE and INSERT in onelists20 Apr
  • Re: UPDATE and INSERT in oneJohan Höök20 Apr
    • INSERT ... ON DUPLICATE KEY UPDATE seems so close and yet so far...Daevid Vincent28 Apr
      • Re: INSERT ... ON DUPLICATE KEY UPDATE seems so close and yet sofar...Philip Hallstrom28 Apr
        • RE: INSERT ... ON DUPLICATE KEY UPDATE seems so close and yet so far...Daevid Vincent30 Apr
  • Re: UPDATE and INSERT in oneDavid Precious20 Apr
• Re: UPDATE and INSERT in onewang shuming20 Apr