UPSERT *not* INSERT or REPLACE

http://en.wikipedia.org/wiki/Upsert Insert Update stored proc on SQL Server Is there some clever way to do this in SQLite that I have not thought of? Basically I want to update three out of four columns if the record exists. If it does not exist, I want to INSERT the record with the default (NULL) value for the fourth column. The ID is a primary key, so there will only ever be one record to UPSERT

[tmsanrinsha]

ON DUPLICATE KEY UPDATE

[synboo]

SQLiteでON DUPLICATE KEY UPDATEがないので代替の方法2