Update an SQLite Table

Important Note

If you do not specifiy a where clause the update will be applied to the entire table!

Update Single Column

 
UPDATE person 
  SET age = 0
 WHERE age = '' OR age IS NULL

Update Multiples Columns

 
UPDATE person 
  SET age = 70,
      gender = 'M'
 WHERE firstname = 'Trump'

Schema and Data use on this page