MySQL skills replace into

Most of the time we want to determine whether a record exists, if it exists, it will be updated, and will not be inserted! The usual practice is to write an IF Exist to make a judgment, but now MySQL gives us a more straightforward statement that is replace into!

The syntax for REPLACE into is similar to insert into:

REPLACE into B_history (

Field name 1, field Name 2 ....

)

VALUES

(

Data 1, data ......

）

of course, it's important to note that he was updated according to the primary key field, that is, the primary key field is updated or added

MySQL skills replace into