wang shuming Fri, 20 Apr 2007 02:21:03 -0700
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