I am trying to insert many rows into my table, some of which violate a foreign key constraint on that table. I want to SKIP adding the rows that violate this constraint and add all the correct rows successfully. However, I get an error even if I use insert or ignore
in my query.
Is there any way to do this in SQLite?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…