How to overwrite or skip same data in SQLite ?

[Gamebit34]

Hello I have a project that location updates save in a SQLite database, but when new location comes from update if there is same data in the table I want to skip or overwrite it.

 

[Deleted User]

Thread moved to Android Development forum

 

[Deleted User]

You can use the Sqlite REPLACE statement to replace existing rows

https://www.tutlane.com/tutorial/sqlite/sqlite-replace-statement

Set up a UNIQUE constraint on the column you wish to replace, and it should work.

 

[Gamebit34]

You can use the Sqlite REPLACE statement to replace existing rows

https://www.tutlane.com/tutorial/sqlite/sqlite-replace-statement

Set up a UNIQUE constraint on the column you wish to replace, and it should work.

Thank you sir I set the values as primary key and solved the problem.