Insert or Update Table SQLite

Question

My table looks something like

table (id, attribute, value, expires, static)

I'd like to be able to update this table for new values of value, expires or static when an entry for an id/attribute pair that already exists. I would like to create a new entry for every new id/attribute pair and every new id.

I am new at using sqlite and have seen a few posts similar to my problem like SQLite - UPSERT *not* INSERT or REPLACE but they do not fully address what I'm trying to do. Maybe its my approach and I need a different table format.

Please let me know your thoughts/suggestions.

Which programming language are you using? – CL. Mar 29 '15 at 07:08 — CL., Mar 29 '15 at 07:08
C++, using the DML commands – awpitt13 Mar 29 '15 at 07:19 — awpitt13, Mar 29 '15 at 07:19
Are you using the C API or some C++ library? – CL. Mar 29 '15 at 12:15 — CL., Mar 29 '15 at 12:15
This is all being done in Qt – awpitt13 Mar 29 '15 at 16:46 — awpitt13, Mar 29 '15 at 16:46

score 1 · Accepted Answer · answered Mar 29 '15 at 17:23

1

Just put the logic into your program:

bool ok = query.exec("UPDATE ...");
...
if (query.numRowsAffected() == 0) {
    ok = query.exec("INSERT ...");
    ...
}

answered Mar 29 '15 at 17:23

CL.

158,085
15
181
214

Insert or Update Table SQLite

1 Answers1

Linked