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

Reply via email to