I am writing a music database, and I need to insert into album table the path to its cover. However, not every album has a cover in its directory, so I've made an algorithm that only gets the albumID that has a cover. My question is - how can I insert value into one column in a row with a specific ID (or name)? I have tried this -
"insert into albums (cover_path) values ('%s') WHERE albumID=%d"
but it sais that theres an error at WHERE. How can I do this? I am using sqlite3 and C++. Thanks!