If you develop an application that supports not only MySQL database but also other relational database management systems (RDBMS), you should avoid using the REPLACE statement because other RDBMS may not support it. Instead, you can use the combination of the DELETE and INSERT statements within a transaction