MySQL exists the record is updated, the SQL that does not exist is inserted into the record

INSERT Test (ID, Name) VALUES (1, ' Hello ') on DUPLICATE KEY UPDATE name= ' baby ';

Raw data:

Post-run data:

If you specify an on DUPLICATE KEY update and the insert row causes duplicate values to appear in a unique index or primary KEY, the old line UPDATE is performed.

If the row is inserted as a new record, the value of the affected row is 1, and if the original record is updated, the value of the affected row is 2.

MySQL exists the record is updated, the SQL that does not exist is inserted into the record