データの更新 (UPDATE) [SQLite]

UPDATE

UPDATE table_name SET column_1 = 値1, column_2 = 値2, … WHERE 条件式;

update users set name = 'Yamada', age = 25 where id = 1;Code language: SQL (Structured Query Language) (sql)

参考：

UPDATE 文 – データの更新 | DBOnline

UPDATE – SQLite3 でデータを更新 | GRAYCODE

Learn SQLite UPDATE Statement with Examples | SQLite Tutorial

SQLite UPDATE Query | Tutorials Point

UPDATE syntax in SQLite – Stack Overflow

NULL 値に更新する

update users set name = 'Tanaka', age = null where id = 2;Code language: SQL (Structured Query Language) (sql)

参考：

how to update a column to null conditionally – Stack Overflow

UPSERT

参考：

SQLite3 でレコードがなければ追加、あれば更新 UPSERT | arupaka の日記

upsert | SQLite Query Language [Official]