I'm looking to "mark" entries of my SQLite database. This following command will add new entries from the other_table
:
INSERT OR IGNORE INTO landing_table (idx)
SELECT gidx FROM other_table
However, I want to update only the entries that don't exist in landing_table
that do exist in other_table
to have the value computed set to 1.
INSERT OR IGNORE INTO landing_table idx (idx, computed)
SELECT gidx FROM other_table
AND SET computed=1
Obviously this isn't correct. I would like to do this in a single insert statement rather than an insert and future UPDATE
statement.
Aucun commentaire:
Enregistrer un commentaire