If this record exists in mysql, it is updated. If this record does not exist, the SQL statement of the record is inserted.

If this record exists in mysql, it is updated. If this record does not exist, the SQL statement of the record is inserted.

INSERT test (id, name) values (1, 'Hello') on duplicate key update name = 'baby ';

Raw data:

Data after running:

If you specify on duplicate key update and insert a row, DUPLICATE values will appear in a UNIQUE index or primary key, the old row will be updated.

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