> Naveen,
>
> There is no way to do what you want directly in SQL. You are looking for an
> INSERT OR UPDATE type of functionality, this does not exist in SQL.
>
> Your program can retrieve the rowid of a conflicting insert by doing a select
> before the insert. If there is a conflicting
Naveen Nathan wrote:
On a duplicate entry/conflict I would like to retrieve the rowid of the
conflicting entry; by possibly updating columns, or replacing the row
entirely while ensuring the rowid doesn't change.
On an INSERT OR REPLACE it deletes the existing row and inserts the
specified data
2 matches
Mail list logo