REPLACE
REPLACE
SQLite Language Reference Documentation
See Also
Example
Collapse All
Expand All
SQL As Understood By SQLite
REPLACE
sql-statement ::=
REPLACE INTO [ color="#ff3434">database-name .] color="#2c2cf0"> table-name color="#2c2cf0"> [(
column-list )] color="#2c2cf0"> VALUES ( value-list color="#2c2cf0"> ) |
REPLACE INTO [database-name color="#2c2cf0"> .]
table-name
[( column-list color="#2c2cf0"> )]
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.