A simple introduction to MySQL replace

Today classmate Discuz upgrade appears the primary key duplication, resulting in data insertion unsuccessful problem, and then looked up, said the method is to replace insert into with replace into, and then the replace into to the query, the following to do a brief introduction

1. Replace into

replace into is similar to insert, except that replace into first attempts to insert data into the table, 1. If you find that this row of data is already in the table (judging by a primary key or a unique index), the row data is first deleted and then the new data is inserted. 2. Otherwise, insert the new data directly.

2. Replace (object,search,replace)

the substitution of strings, for example:

Replace the AA in the Name field in the Tables table with BB and save to the database.

A simple introduction to MySQL replace