sqlwrite - overwrite existing records

6 次查看（过去 30 天）
Ben Mercer
Ben Mercer 2018-12-13
评论： MEP 2022-1-25
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.
Many thanks,
Ben
  2 个评论
gaoliming gao
gaoliming gao 2020-6-9
It seems sqlwrite does not have the features.
Use try, catch statement, or use execute function with CONLICT ON command for postgresql.
MEP
MEP 2022-1-25
I have the same problem, how can I solve it?

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Dredging Production
Are you using an ODBC connection? If yes you could try whether 'update' does the job:
https://www.mathworks.com/help/database/ug/database.odbc.connection.update.html
However, I'm using a JDBC driver, and this function works for ODBC only - I guess.
If you know a solution for JDBC, I'd llike to hear it. Thank you!

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品


版本

R2018b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by