Detailed explanation of replace into example of mysql

This article mainly introduces the relevant information about the detailed explanation of the replace into instance of mysql. Friends in need can refer to the detailed explanation of the replace into instance of

##mysql

insert data into the table.

index ), first delete this row of data, and then insert new data.

It should be noted that the table into which data is inserted must have a primary key or a unique index! Otherwise, replace into will insert data directly, which will result in duplicate data in the table.

There are three ways to write replace into in MySQL:

 replace into table(col, ...) values(...)
 replace into table(col, ...) select ...
 replace into table set col=value, ...

SELECT LAST_INSERT_ID() from dual

The above is the detailed content of Detailed explanation of replace into example of mysql. For more information, please follow other related articles on the PHP Chinese website!