MySQL replace into statement

MySQL Replace statement introduction

　MySQL's replace statement is a MySQL extension to the SQL standard statement.

Official definition: REPLACE works exactly like INSERT, except this if an old row in the table have the same value as a new row for a PRIMA RY KEY or a UNIQUE index, the old row was deleted before the new row is inserted.

Explanation: If the primary key or unique key of the newly inserted row already exists in the table, the original record is deleted and the new row is inserted, and if it does not exist in the table, it is inserted directly

Note: To use the MySQL REPLACE statement, at least Insert and delete permissions are required. There is a function in MySQL called replace (), which is not the same thing as the replace statement described here.

MySQL Replace Statement Example

1 Replace  into table_name (col_namevalues(...) 2 Replace  table_name (col_nameSelect
3 Replace  into Set col_name =value, ...

MySQL replace into statement