I'm using the sqlwrite method to write tables of data into an SQLite database. If there are existing records in the database with the same primary key value, sqlite throws an error. I'd like it to instead overwrite those existing records.
I've seen on other forums that in SQL, you can use the "REPLACE" command, which behaves like "INSERT", but overwrites records with a conflicting primary key, rather than throwing an error. However, it doesn't look like this option is accessible from outside of sqlwrite.
Another option would be to pre-emptively find and delete any records with a conflicting primary key. Is it possible for Matlab to programmatically determine which field is the primary key of a SQL table? I'd rather not have to hard code it separately if possible.