Question

What is the use of UPADTE query in SQLIte?

Answer 1

The UPDATE query is used to modify the existing records in the SQLite table. You have to use the WHERE clause to modify a specific row otherwise all rows will be updated.

Syntax:

UPDATE table_name    

SET column1 = value1, column2 = value2...., columnN = valueN    

WHERE [condition];