update multiple columns sqlite code example
Example 1: sql server update multiple columns at once
UPDATE Person.Person
Set FirstName = 'Kenneth'
,LastName = 'Smith'
WHERE BusinessEntityID = 1
Example 2: update multiple columns in sql
UPDATE table-name SET column-name = value, column-name = value WHERE condition = value
Example 3: update sqlite
UPDATE table
SET column_1 = new_value_1,
column_2 = new_value_2
WHERE
search_condition
ORDER column_or_expression
LIMIT row_count OFFSET offset;