> 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
Hi Folks,
i
I'm unsure if SQLite provides the functionality I seek.
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
3 matches
Mail list logo