With You can use the Hypothetical Here is an example that updates the customer address with ID 6: Now, the If you want to modify Now, the
SQLite
Of UPDATE The query is used to modify existing records in the table. You can use the
WHERE
Clause to update the selected rows, otherwise all rows will be updated. 1.18.1. Grammar ¶
WHERE
Of the clause
UPDATE
The basic syntax of the query is as follows:UPDATE table_name
SET column1 = value1, column2 = value2...., columnN = valueN
WHERE [condition];
AND
Or
OR
Operator to combine N quantity conditions. 1.18.2. Example ¶
COMPANY
The table has the following records:ID NAME AGE ADDRESS SALARY
---------- ---------- ---------- ---------- ----------
1 Paul 32 California 20000.0
2 Allen 25 Texas 15000.0
3 Teddy 23 Norway 20000.0
4 Mark 25 Rich-Mond 65000.0
5 David 27 Texas 85000.0
6 Kim 22 South-Hall 45000.0
7 James 24 Houston 10000.0
sqlite> UPDATE COMPANY SET ADDRESS = 'Texas' WHERE ID = 6;
COMPANY
table has the following records:ID NAME AGE ADDRESS SALARY
---------- ---------- ---------- ---------- ----------
1 Paul 32 California 20000.0
2 Allen 25 Texas 15000.0
3 Teddy 23 Norway 20000.0
4 Mark 25 Rich-Mond 65000.0
5 David 27 Texas 85000.0
6 Kim 22 Texas 45000.0
7 James 24 Houston 10000.0
COMPANY
In the table
ADDRESS
And
SALARY
Column, you do not need to use the
WHERE
Clause, the query
UPDATE
is as follows:sqlite> UPDATE COMPANY SET ADDRESS = 'Texas', SALARY = 20000.00;
COMPANY
table has the following records:ID NAME AGE ADDRESS SALARY
---------- ---------- ---------- ---------- ----------
1 Paul 32 Texas 20000.0
2 Allen 25 Texas 20000.0
3 Teddy 23 Texas 20000.0
4 Mark 25 Texas 20000.0
5 David 27 Texas 20000.0
6 Kim 22 Texas 20000.0
7 James 24 Texas 20000.0