INSERT ... ON DUPLICATE KEY UPDATE

有这么一个场景，插入数据的时候，如果主键存在，则update；如果主键不存在，则insert。Mysql中提供了这样的用法：ON DUPLICATE KEY UPDATE。

执行的时候发现被影响的行数为2

官网是这么解释的

With ON DUPLICATE KEY UPDATE, the affected-rows value per row is 1 if the row is inserted as a new row, 2 if an existing row is updated, and 0 if an existing row is set to its current values. If you specify the CLIENT_FOUND_ROWS flag to the mysql_real_connect() C API function when connecting to mysqld, the affected-rows value is 1 (not 0) if an existing row is set to its current values.