REPLACE

Alias for INSERT OR REPLACE

Synopsis:

 REPLACE INTO [database-name .] table-name [(column-list)] VALUES (value-list) | 
  
 REPLACE INTO [database-name .] table-name [(column-list)] select-statement

Description:

The REPLACE command is an alias for the INSERT OR REPLACE variant of the INSERT command. This alias is provided for compatibility with MySQL.