MySQL exists is updated, no new

Insert Ignore

When data is inserted, such as when an error occurs, such as repeating data, no error is returned, only as a warning.

Insert ignore into table (Col1,col2) VALUES ('val1','val2');

On duplicate key update

When primary or unique repeats, the UPDATE statement is executed

INSERT into table (a,b,c) VALUES (1,2,3) on DUPLICATE KEY UPDATE c=c+1

Replace into

If there is a record with the same primary or unique, it is deleted first. Insert a new record again.

Replace into table (col1,col2) VALUES ('val1','val2');

MySQL exists is updated, no new