datainsert is throwing an error due to a preexisting primary key. How can I make it keep going on error?

1 次查看（过去 30 天）

Will Kinsman 2016-4-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/281407-datainsert-is-throwing-an-error-due-to-a-preexisting-primary-key-how-can-i-make-it-keep-going-on-er

评论： Will Kinsman 2016-4-28

In using datainsert, I am inserting about 50k rows into my database (mySQL,JDBC). My problem is that I keep on getting thrown error messages when there is a repeat primary key, interrupting and stopping my insertion.

I would like it to behave such that IF it tries to insert and fails, it simply moves on in the insertion. I see a few solutions:

be informed of a feature of datainsert I was unaware of that get it to behave like this
use a dynamicSQL query instead, since these continue even if an error is thrown
perhaps fastinsert does not behave like this
import all primary keys from the table, do the setdiff function and THEN datainsert. This is computer intensive as my database is too big for this to be a reasonable option.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Will Kinsman 2016-4-28

I have thought of a fifth solution that might be ideal. Datainserts seem to start at the bottom row and work up. I loop that says "while my row insertion cell array is not empty, keep trying to insert and on failure (catch) delete the last row".

This is not ideal as a lot of rows will may need to be deleted until the error one is reached but is at least a start. Let me know if anyone has any ideas.

请先登录，再进行评论。

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