4 ms·
I'm torn on whether always forcing an explicit SET for ON CONFLICT UPDATE is good practice. It would make for much cleaner code to just update every column wit
by binarymax 8y ago
I'm torn on whether always forcing an explicit SET for ON CONFLICT UPDATE is good practice. It would make for much cleaner code to just update every column with the supplied insert values (as an option). Or maybe I'm just lazy (heck that's why I like UPSERTs in the first place!)
- konsumer 8y agoINSERT OR REPLACE does this. http://www.sqlitetutorial.net/sqlite-replace-statement/ http://www.sqlitetutorial.net/sqlite-replace-statement/