Replace usage of the mysql character replacement function

Replace can replace characters in mysql, but if you really want to update the replace content, we also need to combine the update operation.

Replace can replace characters in mysql, but if you really want to update the replace content, we also need to combine the update operation.

Example

The Code is as follows:
UPDATE 'addonarticle' Set 'body' = REPLACE ('body', 'Ah Meng', Xiao Xiong ')

In this way, the content in your field body is replaced.

Replace

The Code is as follows:
Replace into table (id, name) values ('1', 'A'), ('2', 'bb ')

This statement inserts two records into the table. If the primary key id is 1 or 2 does not exist
It is equivalent

The Code is as follows:
Insert into table (id, name) values ('1', 'A'), ('2', 'bb ')

Data is not inserted if the same value exists.