SQL As Understood By SQLite
REPLACE
sql-statement ::= |
REPLACE INTO [database-name .] table-name [(
column-list )] VALUES ( value-list ) | REPLACE INTO [database-name .] table-name [( column-list )] select-statement |
The REPLACE command is an alias for the "INSERT OR REPLACE" variant of the INSERT command. This alias is provided for compatibility with MySQL. See the INSERT command documentation for additional information.