Shulou(Shulou.com)06/01 Report--

The following brings you about the principle of implementing upsert operation in MySQL, I believe you must have seen similar articles. What's the difference in what we bring to you? Let's take a look at the body part. I believe that after reading the principle of implementing upsert operation in MySQL, you will definitely gain something.

The implementation principle of this operation is to determine whether to insert or update by judging whether there is a primary key conflict in the inserted record. When there is a primary key conflict, the update operation is performed (using the parameters after the ON DUPLICATE KEY UPDATE statement). If there is no conflict, the insert operation is performed.

INSERT INTO t_pro_gift

( _id,

name,

age )

VALUES

( 1,

'hello',

24 )

ON DUPLICATE KEY UPDATE

id = 1,

name = 'world',

age = 55

For the principle of implementing upsert operation in MySQL above, do you think it is what you want? If you want to know more about it, you can continue to pay attention to our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.