作用
主键或唯一索引重复时,执行UPDATE操作;
语法
INSERT INTO table (column_list)
VALUES (value_list)
ON DUPLICATE KEY UPDATE
c1 = v1,
c2 = v2,
...;
返回值说明
- If the new row is inserted, the number of affected-rows is 1(insert操作);
- If the existing row is updated, the number of affected-rows is 2(update操作,前后值不同);
- If the existing row is updated using its current values, the number of affected-rows is 0(update操作,前后值相同);
参考: