Example Analysis of replace into in mysql

This article shares with you the content of the sample analysis of replace into in mysql. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Detailed explanation of replace into example of mysql

1. If you find that there is already this row of data in the table (judged by the primary key or unique index), delete the row of data first, and then insert the new data.

2. Otherwise, insert the new data directly.

It is important to note that the table that inserts data must have a primary key or unique index! Otherwise, replace into inserts the data directly, which results in duplicate data in the table.

There are three ways to write replace into in MySQL:

The code is as follows:

Replace into table (col,...) Values (...) Replace into table (col,...) Select... Replace into table set col=value,...

Extension: mysql gets the last primary key corresponding to the insertion (the average user gets the primary key order number of the order table)

SELECT LAST_INSERT_ID () from dual Thank you for your reading! This is the end of this article on "sample Analysis of replace into in mysql". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!