更新时间:2023-02-07 18:26:47
使用 ON DUPLICATE KEY UPDATE,每行的受影响行值为 1,如果该行作为新行插入,如果更新现有行,则为 2,并且0 如果现有行设置为其当前值
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