插入
INSERT IGNORE INTO test (`f1`, `f2`, `f3`) VALUES (v1,v2,v3);
更新
update test set f1=v1,f2=v2 where f3=v3;
插入
INSERT IGNORE INTO test (`f1`, `f2`, `f3`) VALUES (v1,v2,v3);
更新
update test set f1=v1,f2=v2 where f3=v3;
转载于:https://www.cnblogs.com/guochunyi/p/6232342.html